Databases Quiz 3

What term is used for a database made up of only one table?

• Single table database

• Flat table database

• Flat file database

• Relational database

Which of the following pieces of information would be included in a data dictionary?

• entity/table name

• attribute/field names

• primary key

• data types

Which type of validation ensures that data must be entered into a field or form?

• Lookup

• Range check

• Field size

• Presence check

What is a field length check?

• Data must meet certain requirements on the number of characters

• Data must be selected from a list

• Data must fit within a specified range

• Data must be set to number data type

Which type of validation means the user must select an option from a list?

• Restricted choice

• Lookup Wizard

• List

• Selection

What is range validation?

• The data must be selected from a list

• The data length must be a certain amount of characters

• The data in the field must meet certain limits

• Data must be entered for every record

Which of the following must be included in a query design?

• Tables

• Data type

• Fields

• Search criteria