N5 Database Quiz

A (a)   key is used to uniquely identify a record in a table

A (a)   key is used to link the data in multiple tables

What are attributes also known as in a relational database?

• Fields

• Tables

• Codes

• Scripts

Which data type is used to store hours, minutes, and seconds?

• Date

• Time

• Number

• Text

What type of data only holds two values?

• Boolean

• Text

• Number

• Date

What type of data would you use to store a decimal number like "5.13"?

• Text

• Number

• Date

• Boolean

What type of data can be used as a primary key?

• Any data that is unique

• Only numeric data

• Only text data

• Only date data

Which data type is best suited to store a telephone number?

• text

• number

• boolean

• date / time

What happens when a primary key from one table is copied to another table?

• It becomes a foreign key

• It becomes a composite key

• It becomes a unique key

• It becomes a secondary key

Put these in order to create an SQL query that will display the cars in the Carntyne showroom

• AND showroomLoc = "Carntyne"

• ORDER BY make ASC;

• SELECT make, model, reg

• FROM cars, showrooms

• WHERE cars.showroomID = showroom.showroomID