Which of the following is a definition of the term ‘Primary Key’?
A field in a database that uses the values in other fields to perform a calculation
A field in a table that is used to hold one of two values, either true or false
A field in a table that contains values used to uniquely identify each record in the table
Which of the following is a definition of the term ‘Foreign Key’?
A field in a table that can only contain text
A field in one table that is used as link to a field in another table
A hidden field in a table that cannot be edited or accessed by users
Which of the following is a definition of a ‘flat file database’?
A paper based version of a database
A database file that has been compressed
A database with one table only
Which of the following is a definition of a relational database?
A database that is linked to a website
A database containing several tables, linked using primary and foreign keys
A database that is linked to another database
The ‘text’ field type can be used to store which of the following?
Only letters such as A, B, C, a, b, c
Any combination of characters including punctuation marks, letters, symbols and numbers
Single characters only
The ‘Boolean’ field type can be used to store which of the following?
Dates
True or False
Any data, where the database package will assign an appropriate data type after inspecting the data entered
The ‘number’ field type can be used to store which of the following?
Only whole numbers
The result of calculations
Any numeric value
Altering the format to display data using the 24-hour clock would apply to which of the following field types?
Date
Time
Boolean
Which of these best describes an insert anomaly?
When only one field of data can be inserted
When a table only permits new data in all fields
When any change in input is independent of other records
Which of these best describes a delete anomaly?
When a table only permits deleting data across a whole field