Databases Quiz 1

What is a database?

• A collection of information that is organised into a structure

• A column in a database table

• A row in a database table

• A unique ID that identifies an entry

What is a database table?

• A column in a database table

• A unique ID that identifies an entry

• A collection of related data about a particular item or entity

• A row in a database table

What is a record in a database?

• A unique ID that identifies an entry

• A column in a database table

• A collection of related data about a particular item or entity

• A row in a database table

What is a field in a database?

• A collection of related data about a particular item or entity

• A column in a database

• A row in a database

• Restrictions on what may be entered

How many records are shown in the table? (see image)

• 7

• 42

• 5

• 35

How many fields are shown in the table? (see image)

• 5

• 6

• 30

• 36

What is the data type of the Salary field?

• Boolean

• Text

• Number

• Date

What is the data type of the E-name field?

• Boolean

• Text

• Number

• Date

What is a primary key?

• A password used to access the database

• The first record in a database table

• A field with contents that can be used to uniquely identify a record in the table

• Restrictions on what may be entered into a field

What is validation?

• Restrictions on what may be entered into a field

• Testing to check that information displays as expected

• A field with contents that can be used to uniquely identify a record

• A report run to find records that meet specified criteria