GATE | GATE-CS-2015 (Set 2) | Question 11

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 that the sum of the accounts x and y should remain constant is that of

(A) Atomicity
(B) Consistency
(C) Isolation
(D) Durability

Answer: (B)

Explanation: Consistency in database systems refers to the requirement that any given database transaction must only change affected data in allowed ways, that is sum of x and y must not change.

Quiz of this Question

My Personal Notes arrow_drop_up

Recommended Posts:

0 Average Difficulty : 0/5.0
No votes yet.

User Actions