Home › GATE CSE › computerscience › Database Management Systems › A power cut interrupts a bank transfer after the…
A power cut interrupts a bank transfer after the debit but before the credit. Which ACID property ensures the debit is undone too?
AAtomicity
BConsistency
CIsolation
DDurability
Answer & Solution
Correct answer: A. Atomicity
Atomicity is the all-or-nothing promise. A transaction either commits all its changes or none. The half-completed transfer (debit done, credit pending) violates atomicity, so on restart the DBMS uses its log to roll back the partial debit. Consistency, isolation and durability deal with invariants, concurrency, and crash survival of committed work respectively.
Related questions
The main reasons production DBMSs avoid shadow paging in favour of WAL are that shadow pagWhat is the purpose of a Compensation Log Record (CLR) in ARIES?ARIES recovery is structured as exactlyFuzzy checkpoints differ from naive checkpoints byIn standard log-based recovery, the order of operations isAfter a crash, with checkpointing, the recovery system scans the logA complete log record for a write operation includesPer WAL semantics, a transaction is officially committed at the moment