PrepAway - Latest Free Exam Questions & Answers

Which of the following database controls would ensure that the integrity of transactions is maintained in an o

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