Database Quiz

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 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

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 a presence check?

• A check used to make sure that a database has been created

• A check used to make sure that database images appear in reports as they should

• A check used to ensure that a field is not left blank

• A check used to ensure that every table has data entered

Which validation rule is applied when the data in a particular field can only be from a preset list of values?

• Range check

• Restricted choice

• Presence check

• Length check

0 or >100 will find numbers

• Between 0 and 100 only

• Numbers less than 99

• 0 or greater than 100

• Numbers greater than 100