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. A quick scan of the data in the First Name field in the database yields the numbers 3 and 7 and an asterisk. What kind of check should you run on this field?
A) A) completeness check
B) alphabetic check
C) consistency check
D) check digit

Question

Quizplus · Accepted Answer

Since the First Name field contains numbers and an asterisk, an alphabetic check should be run to ensure that only letters are inputted into the field. Completeness check would check if there is data present in the field, consistency check checks if the data in the field matches the values in other fields, and check digit is typically used for numerical fields to ensure that they are entered correctly (such as in credit card numbers or social security numbers).

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