ARIES uses a ___________ to identify log records, and stores it in dat – McqOptions

MCQOPTIONS

1.	ARIES uses a ___________ to identify log records, and stores it in database pages.
A.	Log sequence number
B.	Log number
C.	Lock number
D.	Sequence
Answer» C. Lock number

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.