DC2012 Chapter 10

A(n) ____ digit is a number(s) or character(s) that is appended to or inserted into a primary key field.

• Check

• Index

• Insertion

• Integer

A(n) ____ check is a validity check performed on data like that in the accompanying figure, which ensures users enter only numeric data into a field.

• Range

• Numeric

• Completeness

• Consistency

A(n) ____ contains data about each file in a database and each field in those files.

• glossary

• repository

• index

• table of contents

A DBMS uses the ____ to perform validation checks.

• data server

• data mart

• data warehouse

• data dictionary

A(n) ____ value is the one that a DBMS initially displays in a field.

• query

• start

• initial

• default

A(n) ____ is a request for specific data from a database.

• query

• index

• ask

• inquiry

A(n) ____ language consists of simple, English-like statements that allow users to specify the data to display, print, or store.

• report

• query

• specification

• inquiry

A DBMS places a copy of the record prior to a change, called the ____ image, in the log.

• prior

• before

• static

• dynamic

A DBMS that creates a log usually provides a(n) ____ utility that uses the logs and/or backups to restore a database when it becomes damaged or destroyed.

• recovery

• restoration

• resumption

• baseline

____ backup is a backup plan in which all data is backed up whenever a change is made.

• Integrated

• Continuous

• Dynamic

• Automated