Exam 10: Database Management

Figure 10-2 For the database pictured in Figure 10-2, the ____________________ defines the maximum number of characters a field can contain.

In a database, the data ____ specifies the kind of data a field can contain and how the field is used.

A relational database typically processes and summarizes large numbers of records efficiently.

A(n) ____________________ is a database that stores data in tables that consist of rows and columns.

Discuss at least three applications appropriate for an object-oriented database.

A(n) ____________________ allows users to design a report on the screen, retrieve data into the report design, and then display or print the report.

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

Individual groups or departments often extract data from a data warehouse to create their data stations .

In a relational database, each row ____.

All DBMSs have built-in backup utilities.

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.

____ is a process designed to ensure the data within the relations (tables) contains the least amount of duplication.

A program determines the ____ by applying a formula to the numbers in the primary key value.

Deleting unneeded files ____ storage space.

A(n) ____ is a program with which users interact that generally has a more user-friendly interface than a DBMS.

Validity checks, sometimes called ____________________, reduce data entry errors.

____________________ is a collection of unprocessed items, which can include text, numbers, images, audio, and video.

In a rollforward , the DBMS uses the log to undo any changes made to a database during a certain period, such as an hour.

For a computer to produce correct information, the data that is input into a database must have integrity.

To access data in a ____, users fill in a form on a Web page.