Exam 11: Information and Data Management: Organizing, Verifying, Maintaining, and Accessing

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.

Data in a database is less vulnerable than data in file processing systems.

COGNITIVE ASSESSMENT What is data redundancy?

A(n) ____________________ verifies that a required field contains data.

A common reason to change a record is to update old data with new data.

In a relational database, users can set up a relationship between tables at any time, but the tables must have a common row or field.

COGNITIVE ASSESSMENT Which term is used to describe the practice that users' access privileges are limited to the lowest level necessary to perform required tasks?

Some report generators allow you to create a webpage, which can be interactive.

COGNITIVE ASSESSMENT Which term does a user of a relational database use to refer to a file?

Key fields link data together in a database.

COGNITIVE ASSESSMENT While working with a database, you encounter a wizard. What best describes the purpose of a wizard?

COGNITIVE ASSESSMENT What is DBMS?

A file is a group of related fields.

Check digits are the only type of validity check that is not able to validate data accuracy.

With the database approach, most data items are stored in multiple files, which greatly reduces duplicate data.

COGNITIVE ASSESSMENT If you are running a check that applies a formula to the primary key, what kind of check are you running?

COGNITIVE ASSESSMENT Which of the following statements is NOT true about the database approach?

When a(n) ____________________ no longer is needed, a user deletes it from a file.

Which of the following is an item that contains data, as well as the actions that read or process the data?