Practice mode DBMS and SQL

A money transfer debits one account, and the system crashes before the matching credit is applied. Which ACID property requires that the debit be undone?

Correct answer A. Atomicity

Explanation

Atomicity means a transaction is all or nothing: either every operation takes effect or none does, so a half-finished transfer must be rolled back during recovery. Consistency is the related goal that the total balance remains correct, but atomicity is the property that enforces undoing the partial work. Durability concerns committed transactions, and this one never committed.

Report a problem

Answer checked How we write and check questions

Tip: press A, B, C or D to answer, and N for the next question.

Advertisement

Have a question about this answer?

Your email address will not be published. Required fields are marked *

Links and website addresses are not allowed in comments.