Database Management System Question
Database Management System Question With Answer & Solution
Que. - Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the field of the page.
Que. - The contains a list of pages that have been updated in the database buffer.
Que. - 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.
Que. - 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.
Que. - rolls back all transactions that were incomplete at the time of crash.
Que. - Which lock should be obtained to prevent a concurrent transaction from executing a conflicting read, insert or delete operation on the same key value.
Que. - Once the lower-level lock is released, the operation cannot be undone by using the old values of updated data items, and must instead be undone by executing a compensating operation; such an operation is called
Que. - Which of the following is used for undo operations alone?
Que. - Redo operations are performed exclusively using
Que. - An operation is said to be if executing it several times in a row gives the same result as executing it once.
Showing
851
To
860 of 1293 results