PrepAway - Latest Free Exam Questions & Answers

Which of the following transaction processing features has been violated?

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