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

Question

Quizplus · Accepted Answer

A completeness check is the best type of check to run on the city field because it will ensure that all records have data in this field. A completeness check verifies that a field must contain data to be considered valid, and in this case, it is important for the mailing database to have a complete address field.

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