Exam 10: Database Management

A Web database usually resides on a(n) ____________________.

In a relational database, where does the only data redundancy exist?

COGNITIVE ASSESSMENT Which term does the developer of a relational database use to describe a file?

If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) ____________________ on the Annual Fee field ensures it is a value between $20.25 and $55.50.

The ____________________ identifies users' access privileges, defines the relationships among data, and decides on the proper placement of fields.

COGNITIVE ASSESSMENT What database term is used to describe a request for specific data from the database?

In a database, a(n) ____________________ contains records, a record contains fields, and a field is made up of characters.

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

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

The developer of a relational database refers to a field as which of the following?

Data integrity is important because computers and people use information to make decisions and take actions.

Critical Thinking Questions Case 10-2 In your database course, your instructor has given you a small database that has a lot of invalid data, issuing the challenge to you that you work to apply validation rules to the data and determine what checks need to be applied in order to restore integrity to the data. The instructor tells you that this is a mailing database, and yet you can see at a glance that there are some records with no data in the city field. What kind of check should you run on this field?

Timely information has an age suited to its use.

Which of the following is an advantage of a multidimensional database?

In a log, a DBMS places which of the following?

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

COGNITIVE ASSESSMENT Which of the following is not considered a part of file maintenance?

COGNITIVE ASSESSMENT Which of the following is not one of the qualities associated with identifying the value of information?

COGNITIVE ASSESSMENT Complex DBMSs maintain a listing of activities that modify the contents of a database. What is this listing called?

Applications best suited for relational databases are those whose data can be organized in a two-dimensional table.