Y8 Databases Quiz 2

What are databases used for?

• Storing large amounts of data in an organised way

• Writing novels

• Storing graphics for websites

• Tracking criminals

What does a table in a database consist of?

• Sentences and words

• Fields and records

• Chapters and titles

• Pages and paragraphs

What might a prison use a database for?

• Keeping records of its inmates

• Organizing recreational activities

• Planning meals

• Scheduling guard shifts

Which of the following is NOT a data type in Microsoft Access?

• Text

• Date/Time

• Color

• Currency

What is a primary key?

• A key to the main entrance of a database

• A field that contains data that is unique for each record

• A password to access the database

• The main topic of a database

What is a foreign key?

• A key from another country

• The primary key from another table, when used to make a relationship

• A second primary key

• A primary key stored in another language

What automatically sets a field's data type in Access?

• The field's name

• The data entered into the field

• The database administrator's preference

• The size of the database

Which of the following is a valid data type in Access?

• Autosound

• Autonumber

• Autotext

• Autoimage

How does a relational database manage data?

• By storing data in standalone files

• By organizing data into tables that can relate to each other

• By using a single table to store all data

• By encrypting data into unreadable formats

In a database query, you choose which ​ (a)   you want to display then set your ​ (b)   . As well as normal searches you can also do 'greater than', 'less than' and ​ (c)   queries

• parameter
• criteria
• fields
• tables
• records
• option
• relationship