Home › GATE CSE › computerscience › Database Management Systems › Two cashiers run two transfers concurrently on o…
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.
Related questions
The main reasons production DBMSs avoid shadow paging in favour of WAL are that shadow pagWhat is the purpose of a Compensation Log Record (CLR) in ARIES?ARIES recovery is structured as exactlyFuzzy checkpoints differ from naive checkpoints byIn standard log-based recovery, the order of operations isAfter a crash, with checkpointing, the recovery system scans the logA complete log record for a write operation includesPer WAL semantics, a transaction is officially committed at the moment