______________ is used to minimize unnecessary redos during recovery. – McqOptions

MCQOPTIONS

1.	______________ is used to minimize unnecessary redos during recovery.
A.	Dirty page table
B.	Page table
C.	Dirty redo
D.	All of the mentioned
Answer» B. Page table

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.