Chapter 11 Quiz

Multiple Choice

Two lists showing different values for the same data in different places of a database is an example of

• 
  data redundancy

• data disparity

• data inconsistency

• 
  data irregularity

Multiple Select

Which are Microsoft Access objects? (Select all apply)

• forms

• queries

• tables

• reports

Multiple Choice

Which type of database organizes data by measure and feature attributes?

• Multidimensional database

• 
  Relational database

• 
  Object-oriented database

Multiple Select

Which of the following is a true statement when considering using databases instead of lists? (select all that apply)

• 
  Data can be easily shared among users.

• Data integrity can be ensured with a database.

• Data-entry errors can be minimized with databases.

Multiple Choice

The field that has a unique entry for each record in a database table is called the

• foreign key

• 
  primary key

• logical key

• 
  main key

Multiple Choice

A process to ensure that data in a database is organized most efficiently is called

• 
  centralization

• 
  normalization

• 
  data staging

• 
  integration

Multiple Choice

Which of the following is used to create a subset of data that matches certain criteria and that can be saved for future reference or use?

• 
  Relationship

• 
  Query

• Filter

• Request

Multiple Choice

A field labeled PHONE that accepts data such as [phone] would use the Number data type.

• True

• False

Multiple Choice

A primary key is used to uniquely identify records.

• True

• False

Multiple Choice

Which of the following is not considered metadata?

• Data type

• 
  Field name

• 
  Database name

• Field size