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 checkc. consistency checkb. range checkd. check digit

What will be an ideal response?


Answer: A

Computer Science & Information Technology

You might also like to view...

Reimplement Exercise 4.11 to use multiple threads. Because the current working directory is a process attribute, it is shared by all threads, so you can’t use chdir(2). Instead, use the *at functions to allow 16 worker threads to process different parts of the ?le system at the same time. How much faster is this version compared to the version from Exercise 4.11?

What will be an ideal response?

Computer Science & Information Technology

When multiple fields are used to identify a record, it is called a(n) ________ key

A) natural B) composite C) artificial D) alternate

Computer Science & Information Technology

A ____ search starts looking in the middle of a sorted list, and then determines whether it should continue higher or lower.

A. linear B. quick C. graphic D. binary

Computer Science & Information Technology

A job's state moves from HOLD to WAITING when it's ready to run but is waiting for the CPU.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology