Quiz 6

True or False? An index can improve the accuracy of a query result.

False

Which of the following describes the completeness data quality characteristic?

The degree to which all the required data is present in the data collection

Which of the following describes the timeliness data quality characteristic?

The degree to which the data is aligned with the proper time window in its representation of the real-world

Which of the following describes the conformity data quality characteristic?

The extent to which the data conforms to its specified format

Which of the following describes the consistency data quality characteristic?

The extent to which the data properly conforms to and matches up with the other data

True or False? A form can be used to enter data into a database table.

True

True or False? If a Table A has a foreign key column that refers to the primary key of Table B, and every value of a primary key in Table B is referred to by at least one row in a Table A, than no record in Table B can bedeleted, if DELETE RESTRICT option in effect.

True

True or False? Mandating instantaneous entry of all new data is an example of a preventive data quality action.

True

Listing the exact same customer twice in the list of customers indicates which data quality problem?

Uniqueness

Incorrectly spelling customer's name indicates which data quality problem?

Accuracy

Assume that Table B has a foreign key referring to a primary key in Table A. Which of the following options may result in the following: changing a value of a primary key in a row in Table A will cause a deletion of a foreign key value in a row in Table B?

DELETE SET-TO-NULL?

Missing date of hire information of an employee indicates which data quality problem?

Completeness

What is the purpose of an index?

Increasing the speed of queries