An actual update is not allowed to a data item ____________ – McqOptions

MCQOPTIONS

1.	An actual update is not allowed to a data item ____________
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» B. after the corresponding log record is written out to stable storage

Discussion

No Comment Found

Related MCQs

The shrinking phase is a phase in which?
The two phase locking protocol consists of ____________
A locking protocol is one that ____________
Serializable schedules are ones where ____________
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 ____________
An actual update is not allowed to a data item ____________
In the write ahead logging a _____________ is maintained.
Write ahead logging is a way ____________
A collection of instructions that performs a single logical function is called ____________