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.