Suppose a database system crashes again while recovering from a previous crash. Assume checkpointing is not done by the database either during the transactions or during recovery. Which of the following statements is/are correct?
The same undo and redo list will be used while recovering again.
The system cannot recover any further.
All the transactions that are already undone and redone will not be recovered again.
Correct answer: (A) The same undo and redo list will be used while recovering again.
Explanation
Without checkpoints, recovery restarts from the same log, so the same undo/redo lists are used. Undo/redo are idempotent, so recovery can be repeated and the database stays consistent.
More Transactions and Concurrency Control questions
GATE 2021 CS (CS1) Q42– Let r i(z) and w i(z) denote read and write operations respectively on a data item z by a…
GATE 2020 CS Q47– Consider a schedule of transactions T 1 and T 2. In time order (RX = Read(X), WX =…
GATE 2019 CS Q21– Consider the following two statements about database transaction schedules: I. Strict…
GATE 2016 CS (CS1) Q32– Which one of the following is NOT a part of the ACID properties of database transactions?
GATE 2016 CS (CS1) Q61– Consider the following two phase locking protocol. Suppose a transaction T accesses (for…
GATE 2017 CS (CS1) Q52– In a database system, unique timestamps are assigned to each transaction using Lamport's…