Computer Sciences > GATE 2025 SET-2 > ACID Properties
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?
A
Atomicity
B
Consistency
C
Isolation
D
Durability

Correct : c

The correct answer is Option C — Isolation.
In this scenario, two transactions simultaneously read the same balance of Rs. 11,000 from account A before either of them wrote their update back. Both then proceeded to debit Rs. 10,000 each, but since both read the original value, account A was only debited once (ending at Rs. 1,000 instead of going negative), while account B was credited twice.
This is a classic lost update anomaly — one transaction''s write overwrites the other''s, caused entirely by concurrent access without proper isolation. If isolation had been enforced, the second transaction would have seen the updated balance (Rs. 1,000) after the first committed, and the transfer would have been rejected or the balance correctly updated.
Option A — Atomicity: Not violated. Both transactions completed fully — each read, debited, and credited as intended. Neither was partially executed.
Option B — Consistency: Consistency violations are caused by a single transaction breaking integrity constraints. Here, both individual transactions were internally consistent — the problem arose from their concurrent interaction, which is an isolation issue.
Option D — Durability: Not violated. Both committed changes persisted — in fact, that''s part of the problem. The data was durably stored, just incorrectly due to the isolation failure.
The root cause is clearly Isolation — concurrent transactions were allowed to interfere with each other''s reads and writes.

Similar Questions

A palindrome is a word that reads the same forwards and backwards. In a game of words, a player has the following two plates painted with letters. From...
#1 MCQ
Which number does not belong in the series below? 2, 5, 10, 17, 26, 37, 50, 64
#4 MCQ
Choose the word that is opposite in meaning to the word “coherent”.
#5 MCQ

Related Topics

ACID properties GATE 2025 GATE CS 2025 Set-2 Q27 isolation violation DBMS banking transaction ACID concurrent transaction GATE lost update anomaly dirty read DBMS GATE isolation ACID GATE simultaneous transfer violation GATE computer science DBMS

Unique Visitor Count

Total Unique Visitors

Loading......