GATE 2025 CS (CS2) – Question 27
An audit of a banking transactions system has found that on an earlier occasion, two joint holders of account $A$ attempted simultaneous transfers of Rs. 10000 each from account $A$ to account $B$. Both transactions read the same value, Rs. 11000, as the initial balance in $A$ and were allowed to go through. $B$ was credited Rs. 10000 twice. $A$ was debited only once and ended up with a balance of Rs. 1000.
Which of the following properties is/are certain to have been violated by the system?
Practise this question in The GATE Grind →
Show answer and explanation
Correct answer: (B) Consistency; (C) Isolation
Explanation
Both transactions read the same stale balance of Rs. 11000, so one update overwrote the other (a lost update). That is a failure of isolation: the transactions interfered with each other, which a serial run would have prevented.
The outcome is also inconsistent. B was credited Rs. 20000 but A was debited only Rs. 10000, so the total money in the system changed. A consistent state change must keep that total, so consistency is violated too.
Atomicity is not certain to be violated, because each transfer ran to completion. Durability is not affected either, since the final state was kept. The answer is therefore Consistency and Isolation, options B and C.