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

MCQOPTIONS

1.	If a transaction does not modify the database until it has committed, it is said to use the ___________ technique.
A.	Deferred-modification
B.	Late-modification
C.	Immediate-modification
D.	Undo
Answer» B. Late-modification

Discussion

No Comment Found

Related MCQs

THE_ACTIONS_WHICH_ARE_PLAYED_IN_THE_ORDER_WHILE_RECORDING_IT_IS_CALLED________________HISTORY.?$
THE_________RECOVERY_MODEL_IS_A_SPECIAL-PURPOSE_MODEL_THAT_WORKS_IN_A_SIMILAR_MANNER_TO_THE_FULL_RECOVERY_MODEL.?$
A special redo-only log record < Ti, Xj, V1> is written to the log, where V1 is the value being restored to data item Xj during the rollback. These log records are sometimes called$
Which_of_the_following_statement_is_used_for_changing_Recovery_Model_with_T-SQL_?$
In the __________ phase, the system replays updates of all transactions by scanning the log forward from the last checkpoint?
How many type of backups you can run when the data is in the ‚Äö√Ñ√∂‚àö√ë‚àö‚à´Full‚Äö√Ñ√∂‚àö√ë‚àöœÄ recovery model ?#
____________ using a log record sets the data item specified in the log record to the old value.
Which of the following recovery models requires log backups ?
If database modifications occur while the transaction is still active, the transaction is said to use the ___________technique.
Which the following feature cannot be used in simple recovery mode ?