Which of the following database controls would ensure that the integrity of transactions is maintained in an online transaction processing system’s database?
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.