Computer Sciences > Gate 2016 Set-1 > Transactions
Which one of the following is NOT a part of the ACID properties of database transactions?
A
Atomicity
B
Consistency
C
Isolation
D
Deadlock-freedom

Correct : T

Given:
Four properties related to database transactions: Atomicity, Consistency, Isolation, and Deadlock-freedom.
To find:
The property that is NOT a part of the ACID properties.
Solution:
Let me recall what the acronym ACID stands for in database systems.
A stands for Atomicity, meaning all operations in a transaction succeed, or none do.
C stands for Consistency, ensuring the database moves from one valid state to another.
I stands for Isolation, ensuring concurrent transactions do not interfere with each other.
D stands for Durability, ensuring that committed changes are saved permanently.
Now looking at the options, Deadlock-freedom is given for letter D instead of Durability.
So Deadlock-freedom is definitely not an ACID property.
Answer: (D) Deadlock-freedom

Similar Questions

Consider the following transaction involving two bank accounts x and y. read(x); x := x – 50; write(x); read(y); y := y + 50; write(y) The constraint th...
#58 MCQ
Consider the following database schedule with two transactions, T1 and T2. S = r2(X); r1(X); r2(Y); w1(X); r1(Y); w2(X); a1; a2; where ri(Z) denotes a read op...
#84 MCQ
Suppose a database schedule S involves transactions T1, ....Tn. Construct the precedence graph of S with vertices representing the transactions and edges repres...
#101 MCQ

Related Topics

ACID properties database transactions Deadlock-freedom GATE Computer Sciences 2016 DBMS ACID database management systems transaction properties GATE 2016 Set-1

Unique Visitor Count

Total Unique Visitors

Loading......