a) before the corresponding log record is written out to stable storage
b) after the corresponding log record is written out to stable storage
c) until the whole log record has been checked for inconsistencies
d) all of the mentioned
Answer: a
Explanation: An actual update is not allowed to a data item before the corresponding log record is written out to stable storage
Related Posts
Consider a transaction T1 that committed prior to checkpoint. The <T1 commits> record appears in the log before the <checkpoint> record. Any modifications made by T1 must have been written to the stable storage either with the checkpoint or prior to it. Thus at recovery time ____________
The system periodically performs checkpoints that consists of the following operation(s) ____________
The undo and redo operations must be _________ to guarantee correct behaviour, even if a failure occurs during recovery process.
In the write ahead logging a _____________ is maintained.
Write ahead logging is a way ____________
The state of the data accessed by an aborted transaction must be restored to what it was just before the transaction started executing. This restoration is known as ________ of transaction.
A terminated transaction that has completed its execution successfully is ____________ otherwise it is __________
Join The Discussion