Databases

Which of the following is NOT true of databases?

• You can store large amounts of data.

• You have to use a computer.

• You can search the data.

What term describes a personalised letter which can be sent to customers of a supermarket?

• Report

• Mail merge

• Macro

Which of the following is an advantage to paper-based databases?

• It is easy to add or amend records.

• You do not need any training on how to use the database.

• Data can be sorted and re-sorted easily.

Thinking of data, information and knowledge - which of the following is an example of information?

• The average men's shoe size is nine.

• 9

• If you are to open a shoe shop, you must stock plenty of size nine shoes.

Which of the following holds a single piece of data?

• Table

• Record

• Field

Which validation rule would you use to limit what a user can enter to only a few options, e.g. male or female?

• List check

• Presence check

• Range check

Which of the following is a piece of software used to create databases?

• Google Chrome

• Microsoft Office PowerPoint

• Microsoft Office Access

Which field would be inappropriate in a database of countries?

• Continent

• Population

• First Name

What is the correct definition of primary key?

• The first field in a table.

• A field that contains unique data in each record.

• The field which we will use to search with.

What database feature checks to see if data meets certain rules when entered to a table?

• Table

• Query

• Validation