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) A) completeness check
B) range check
C) consistency check
D) check digit

Question

Quizplus · Accepted Answer

A completeness check is the best choice because it verifies that all required data is present in a field. In this case, the city field should have data for every record in the mailing database. Running a completeness check on the city field will identify records that are missing data and allow you to correct them to restore integrity to the database.

In Your Database Course, Your Instructor Has Given You a Small