PrepAway - Latest Free Exam Questions & Answers

Which of the following database controls would ensure t…

Which of the following database controls would ensure that the integrity of transactions is maintained in an
online transaction processing system’s database?

PrepAway - Latest Free Exam Questions & Answers

A.
Authentication controls

B.
Data normalization controls

C.
Read/write access log controls

D.
Commitment and rollback controls

Explanation:
Commitment and rollback controls are directly relevant to integrity. These controls ensure that database
operations that form a logical transaction unit will complete in its entirety or not at all; i.e., if, for some reason, a
transaction cannot be fully completed, then incomplete inserts/updates/deletes are rolled back so that the
database returns to its pretransaction state. All other choices would not address transaction integrity.


Leave a Reply