IAE Academy

GATE 2024 CS2 Q.19: solution and answer

GATE 2024 · CS2Q.19 · 1 mark · MCQ

Once the DBMS informs the user that a transaction has been successfully completed, its effect should persist even if the system crashes before all its changes are reflected on disk. This property is called

  1. (A)

    durability

  2. (B)

    atomicity

  3. (C)

    consistency

  4. (D)

    isolation

See the question in the paper

Answer and solution

ANSWER

The property is durability, option (A).

Official answer: ASource: Official answer key, GATE 2024 CS2 (IISc Bengaluru)

  1. The ACID properties are atomicity, consistency, isolation and durability. Match the described behaviour to one of them.

  2. The question describes a transaction that the DBMS has reported as successfully completed (committed). Its effect must persist even if the system crashes before all its changes have been written to disk.

  3. This is the guarantee that committed changes are permanent. The recovery manager provides it with a write-ahead log (WAL). The log records of a committed transaction are forced to stable storage before the commit is reported. After a crash, recovery REDOes the committed transactions from the log.

  4. Atomicity means all-or-nothing execution, so incomplete work is undone. Consistency means a transaction takes the database from one valid state to another. Isolation means concurrent transactions do not interfere with one another. None of these is about committed effects surviving a crash.

  5. So the property is durability, option (A).

KEY IDEA

Durability means that once a transaction has committed, its effects persist even if the system crashes. Recovery from the write-ahead log (REDO of committed work) provides this.

WATCH OUT FOR

Choosing atomicity because a crash is involved. Atomicity concerns undoing a transaction that was incomplete at the crash. The question is about a transaction already reported as completed whose effects must still survive, and that is durability.

From the GATE 2024 CS2 paper. Every question of this paper · Download the full paper · All 9 Transactions questions, with notes

More Transactions questions