S3 Databases Knowledge Check 1

A database...

• is a collection of data (fields) about a single person or object

• is the smallest component that holds data

• is a collection of related information about a set of persons or objects

• contains the collection of records which form the database

A field...

• is a collection of data (fields) about a single person or object

• is the smallest component that holds data

• is a collection of related information about a set of persons or objects

• contains the collection of records which form the database

A record is...

• a collection of data (fields) about a single person or object

• the smallest component that holds data

• a collection of related information about a set of persons or objects

• contains the collection of records which form the database

A table...

• is a collection of data (fields) about a single person or object

• is the smallest component that holds data

• is a collection of related information about a set of persons or objects

• contains the collection of records which form the database

What is a data dictionary?

• a list of words and their meanings related to databases

• data types that can be included in a database

• all the records in a specific database

• a plan of how a database is to be created

Which field type is used to store letters or a mixture of letters, numbers and symbols?

• date/time

• number

• boolean

• text

Which field type is used to store numbers?

• date/time

• number

• boolean

• text

Which field type is used to store dates, such as date of birth?

• date/time

• number

• boolean

• text

Which field type would be used to store the password 'P@5sW0rD' ?

• date/time

• text

• number

• boolean

What is the purpose of the Primary Key?

• to enable different records to have the same ID

• to ensure that the data type is set as text

• to uniquely identify a record

• to allow the Primary Lock to be opened