Critical Thinking Questions Case 11-2 in Your Database Course, Your

question 133

Multiple Choice

Critical Thinking Questions Case 11-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?

• A) completeness check
• B) range check
• C) consistency check
• D) check digit

---

Definitions:

Present Value Table

A table that provides factors for calculating the present value of future cash flows based on a certain discount rate over a number of periods.

Interest

The charge for the privilege of borrowing money, typically expressed as an annual percentage rate.