CISA Certified Information Systems Auditor – Question1674

Online banking transactions are being posted to the database when processing suddenly comes to a halt. The integrity of the transaction processing is BEST ensured by:

A.
database integrity checks.
B. validation checks.
C. input controls.
D. database commits and rollbacks.

Correct Answer: D

Explanation:

Explanation:
Database commits ensure the data are saved to disk, while the transaction processing is underway or complete. Rollback ensures that the already completed processing is reversed back, and the data already processed are not saved to the disk in the event of the failure of the completion of the transaction processing. All other options do not ensure integrity while processing is underway.