1.

The __________________ contains a list of pages that have been updated in the database buffer.(a) Dirty page table(b) Page table(c) Dirty redo(d) All of the mentionedI had been asked this question during an interview.This intriguing question comes from ARIES in division Recovery System of Database Management

Answer»

Correct choice is (a) Dirty PAGE table

Easiest explanation - Dirty pages are those that have been updated in MEMORY, and the DISK VERSION is not up-to-date.



Discussion

No Comment Found

Related InterviewSolutions