PrepAway - Latest Free Exam Questions & Answers

Which of the following transaction processing features …

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?

PrepAway - Latest Free Exam Questions & Answers

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