Which one of the following is NOT a part of the ACID properties of database transactions?
Topic-wise GATE CS PYQs with verified steps
GATE CSE 2016 Set 1 · Q22
MCQ1 markEasy
Time
Which one of the following is NOT a part of the ACID properties of database transactions?
Select one answerSingle correct
Pick an option to check
Solution
Step-by-step verified solution
Official answer: D) Deadlock-freedom
Transactions and Concurrency ControlThe standard ACID properties of database transactions stand for:
A: Atomicitiy (all-or-nothing execution)
C: Consistency (preservation of database invariants)
I: Isolation (concurrency control ensuring transactions execute as if in isolation)
D: Durability (committed changes persist even after system failures)
Deadlock-freedom is not one of the ACID properties. Hence, the correct option is D.
Try the question first, then check your work.
Examiner trap
The misconception this question tests
Identify what each letter in the acronym ACID stands for.
This Transactions and Concurrency Control previous year question is Q22 of the GATE CSE 2016 Set 1 paper. Find more GATE CSE PYQs on Transactions and Concurrency Control in Databases, or browse all GATE CSE PYQs.
Free diagnostic
Where do you stand for GATE?
Take the 20-minute diagnostic: the 3 topics that cost you the most marks, and a rank range. Or sit 5 related Transactions and Concurrency Control PYQs now with no account.
One GATE CSE PYQ every morning
An official question by email at 7 AM IST, with a link to its verified solution. Unsubscribe in one click.
Transactions and Concurrency Control in GATE CSE
Transactions and Concurrency Control has 25 GATE CSE PYQs across 20 papers from 2012 to 2026. 7 of them are 1-mark MCQs like this one, and GATE CSE 2016 Set 1 has 2.
How GATE tests Transactions and Concurrency ControlMore from GATE CSE 2016 Set 1
- Q24Which one of the following protocols is NOT used to resolve one form of address to another one?MCQ1 markEasy
- Q20Consider an arbitrary set of CPU-bound processes with unequal CPU burst lengths submitted at the same time to a computer system. Which one of the following pro…MCQ1 markEasy
- Q25Which of the following is/are example(s) of stateful application layer protocols? (i) HTTP (ii) FTP (iii) TCP (iv) POP3MCQ1 markMedium
- Q19Consider the following code segment. x = u - t; y = x * v; x = y + w; y = t - z; y = x * y; The minimum number of total variables required to convert the above…NAT1 markMedium
Independent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.