rolls back all transactions that were incomplete at the time of crash.

Related MCQs

•                        determines which transactions to undo, which pages were dirty at the time of the crash, and the LSN from which the redo pass should start.
• Which of the following is used to get back all the transactions back after rollback?
•                      starts from a position determined during analysis, and performs a redo, repeating history, to bring the database to a state it was in before the crash.
• A concurrency-control policy such as this one leads to              performance since it forces transactions to wait for preceding transactions to finish before they can start.
•                      are used to ensure that transactions access each data item in order of the transactions’          if their accesses conflict.
• Each of a pair of transactions has read data that is written by the other, but there is no data written by both transactions, is referred to as
•                      rollback requires the system to maintain additional information about the state of all the running transactions.
• In the                      phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint.
• The                        policy, allows the system to write modified blocks to disk even if the transactions that made those modifications have not all committed.
• A DBMS uses a transaction ____ to keep track of all transactions that update the database