Two cashiers run two transfers concurrently on overlapping accounts. The ACID property that hides this concurrency from each cashier is
AAtomicity
BIsolation
CConsistency
DDurability
Answer & Solution
Correct answer: B. Isolation
Isolation says each transaction should see the DB as if it were the only one running, even if the DBMS executes many in parallel.
The visible effect must be equivalent to some serial order.
Atomicity covers all-or-nothing, consistency covers invariants, durability covers crash survival.
Keep practising Database Management Systems
Browse all Database Management Systems questions for GATE CSE, or explore more Computer Science topics.