Transactions & ACID · SQL SQL
Which property of ACID ensures that once a transaction has been committed, its effects are permanently recorded in the database, even in the event of…
Practice question from Transactions & ACID (SQL SQL), with the correct answer and a step-by-step solution.
easy · MCQ · Q-3AE7E8
Which property of ACID ensures that once a transaction has been committed, its effects are permanently recorded in the database, even in the event of a system crash or power failure?
- A.Atomicity
- B.Consistency
- C.Isolation
- D.DurabilityCorrect answer
Solution
Durability ensures that completed transactions are recorded permanently in non-volatile storage, surviving subsequent system failures, typically achieved via write-ahead logging.
More from Transactions & ACID
- In PostgreSQL and MySQL, what is the default transaction isolation level?
- Which of the following phenomena can still occur under the 'Repeatable Read' isolation level in standard ANSI SQL, but is prevented in Post…
- What is the primary purpose of the Write-Ahead Logging (WAL) protocol in database transaction management?
- Explain the difference between a 'Dirty Read' and a 'Non-Repeatable Read' anomaly.
Practise more SQL
Sign up free for adaptive practice on this chapter, with instant feedback and hints on every question.
Start practising freeFree to start · No credit card needed