PrepAway - Latest Free Exam Questions & Answers

An IS auditor analyzing the audit log of a database management system (DBMS) finds that some transactions were

An IS auditor analyzing the audit log of a database management system (DBMS) finds that some transactions were partially executed as a result of an error, and are not rolled back. Which of the following transaction processing features has been violated?

A. Consistency

B. Isolation

C. Durability

D. Atomicity

Explanation:

Atomicity guarantees that either the entire transaction is processed or none of it is. Consistency ensures that the database is in a legal state when the transaction begins and ends, isolation means that, while in an intermediate

state, the transaction data is invisible to external operations. Durability guarantees that a successful transaction will persist, and cannot be undone.


Leave a Reply