Question
Once the DBMS informs the user that a transaction has been successfully completed, its effect should persist even if the system crashes before all its changes are reflected on disk. This property is called
Official answer and solution
- Official answer
- A
- From
- Official GATE 2024 answer key
Solution
Recall the definition of the D (Durability) property in ACID transactions.
Among the ACID properties of database transactions:
- Atomicity: Either all operations of the transaction are executed or none are.
- Consistency: Execution of a transaction preserves database integrity constraints.
- Isolation: Concurrent transactions execute as if isolated from one another.
- Durability: Once a transaction commits, its changes are permanent and must survive any subsequent system crash.
Final answer
Option (A)
The answer is the one in the official GATE answer key. The solution is this site's own explanation.
Source
- Paper
- GATE 2024 Computer Science and Information Technology - Set 2 (CS2)
- Question
- 19 of 65
- Section
- Computer Science and Information Technology
Report an error in this question
GATE questions are the work of the organising institutes. This site is independent and is not affiliated with them.