Which of the following controls would provide the GREATEST assurance of database integrity?

A.
Audit log procedures

B.
Table link/reference checks

C.
Query/table access time checks

D.
Rollback androllforward database features

Explanation:
Performing table link/reference checks serves to detect table linking errors (such as completeness
and accuracy of the contents of the database), and thus provides the greatest assurance of database
integrity. Audit log procedures enable recording ofall events that have been identified and help in
tracing the events. However, they only point to the event and do not ensure completeness or
accuracy of the database’s contents. Querying/monitoring table access time checks helps designers
improve database performance, but not integrity. Rollback and rollforward database features ensure
recovery from an abnormal disruption. They assure the integrity of the transaction that was being
processed at the time of disruption, but do not provide assurance on the integrity of the contents of
the database.