Whenever an update operation occurs on a page, the operation stores th – McqOptions

MCQOPTIONS

1.	Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the _______ field of the page.
A.	LSN
B.	ReadLSN
C.	PageLSN
D.	RedoLSN
Answer» D. RedoLSN

Discussion

No Comment Found

Related MCQs

___________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.?$
_______________rolls_back_all_transactions_that_were_incomplete_at_the_time_of_crash.$
___________ 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?
The __________________ contains a list of pages that have been updated in the database buffer.
There are special redo-only log records generated during transaction rollback, called _________ in ARIES.
Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the _______ field of the page.
__________ scheme that records only information about dirty pages and associated information and does not even require of writing dirty pages to disk.
______________ is used to minimize unnecessary redos during recovery.
ARIES supports ___________ operations, which are physical in that the affected page is physically identified, but can be logical within the page.
ARIES uses a ___________ to identify log records, and stores it in database pages.