Databases

What is the definition of a Primary Key?

• The first field in a database table

• A field in a table that contains a unique identifier for each record in the table

• A field in a database that can only contain two values

• A field in the database that has the same value for each record

What is the definition of a Foreign Key?

• A field in a table that is written in another language

• A field in a table that links to the World Wide Web

• A field in a table that cannot be edited or accessed by users

• A field in a table that is used as a link to a field in another table

What is a flat-file database?

• A paper version of a database

• A compressed database

• A database consisting of one table only

• A database consisting of text only

How would you define a relational database?

• A database consisting of data relating to families

• An online database

• A database linked to another database

• A database consisting of multiple tables, that are linked using keys

What type of field would be best to store the following text: "11-00-67"

• Number

• Currency

• Date

• Text

What does a Boolean field store?

• Numbers

• Dates

• True or False

• Any data, with the database automatically choosing the appropriate data type.

What can a number field be used to store?

• Whole numbers only

• All numeric values

• Calculations

• Formulas

Which Act of Parliament ensures the prior consent of users before storing personal information?

• Data Protection Act

• Computer Misuse Act

• Fraud Act

• Copyright, Designs and Patents Act

What is the definition of a database entity?

• Another name for a table

• A way of performing searches and sorts in a database

• It represents people, places, objects or things stored in tables in a database

• A way of linking tables in a database

What is the definition of an database attribute?

• A form of validation that can be used in a database

• An attribute is another terms for table

• An attribute is a characteristic of an entity and will become a field during implementation

• An attribute is another term for field type.