Question
Which one of the following is NOT a part of the ACID properties of database transactions?
Official answer and solution
- Official answer
- D
- From
- Official GATE 2016 answer key
Solution
Recall the definition of ACID properties in transaction processing systems.
The ACID properties of database transactions are:
- Atomicity: All-or-nothing execution of transaction operations.
- Consistency: Execution preserves database integrity constraints.
- Isolation: Intermediate transaction states are hidden from concurrently executing transactions.
- Durability: Committed transaction updates persist even across system crashes.
Deadlock-freedom is a concurrency control management guarantee, not an ACID property. Transactions operating under standard concurrency protocols such as Strict 2-Phase Locking (2PL) satisfy ACID properties but can still encounter deadlocks.
Therefore, Deadlock-freedom is NOT part of ACID.
D
Confusing Durability with Deadlock-freedom.
The answer is the one in the official GATE answer key. The solution is this site's own explanation.
Source
- Paper
- GATE 2016 Computer Science and Information Technology (CS) Session 1
- Question
- 32 of 65, printed as CS Q.22
- 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.