Once the DBMS informs the user that a transaction has been successfully…
2024
Once the DBMS informs the user that a transaction has been successfully completed, its effects should persist even if the system crashes before all its changes are reflected on disk. This property is called
Answer: A. durability — ConceptThe ACID properties describe four independent guarantees of transaction processing. Durability is the post-commit guarantee: after the system…
- A.
durability
- B.
atomicity
- C.
consistency
- D.
isolation
Attempted by 822 students.
Show answer & explanation
Correct answer: A
Concept
The ACID properties describe four independent guarantees of transaction processing. Durability is the post-commit guarantee: after the system acknowledges a commit, recovery must preserve that transaction’s effects across failures.
A DBMS commonly supports this guarantee with stable recovery information, such as a write-ahead log whose commit record is made durable before success is reported.
Application
The stem says the transaction has already been reported as successfully completed and asks for the guarantee that its effects survive a later crash. That condition identifies durability.
Contrast and cross-check
Atomicity governs all-or-nothing completion and rollback of partial work.
Consistency governs preservation of integrity rules between valid database states.
Isolation governs interference among concurrently executing transactions.
Durability governs the continued effect of an acknowledged commit after recovery.
Result
Therefore, the property is durability.
A video solution is available for this question — log in and enroll to watch it.
Explore the full course: Iocl Engineers Officers Grade A Paper 2