A bank transfer commits and the customer is told it succeeded. Seconds later the server loses power. After restart the transfer is still recorded. Which ACID property guarantees this?
Correct answer D. Durability
Explanation
Durability guarantees that once a transaction has committed, its effects survive later failures such as crashes or power loss. DBMSs achieve this by forcing the transaction's log records to stable storage before reporting success, then replaying them during recovery. Atomicity covers incomplete transactions, not completed ones, and isolation concerns interference between concurrent transactions.
Answer checked How we write and check questions
Discussion