If a transaction does not modify the database until it has committed i – McqOptions

MCQOPTIONS

1.	If a transaction does not modify the database until it has committed it is said to use a _______ modification technique
A.	Deferred
B.	Immediate
C.	More than one of the mentioned
D.	None of the mentioned
Answer» B. Immediate

Discussion

No Comment Found

Related MCQs

If the database modifications occur while the transaction is still active, the transaction is said to use the __________ modification technique
A __________ checkpoint is a checkpoint where transactions are allowed to perform updates even while buffer blocks are being written out.
State true or false: Using checkpoints reduces overhead
If a transaction does not modify the database until it has committed it is said to use a _______ modification technique
A____________CHECKPOINT_IS_A_CHECKPOINT_WHERE_TRANSACTIONS_ARE_ALLOWED_TO_PERFORM_UPDATES_EVEN_WHILE_BUFFER_BLOCKS_ARE_BEING_WRITTEN_OUT.?$
If the database modifications occur while the transaction is still active, the transaction is said to use the __________ modification technique$
State true or false: Using checkpoints reduces overhea?
We say that a transaction has been ________ when its commit log record has been output to stable storage.
If a transaction does not modify the database until it has committed it is said to use a _______ modification technique
The value of the data item prior to the write is called as _________