ARIES MCQ

Test your knowledge with important ARIES MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more ARIES MCQs at Bissoy

• ______________ rolls back all transactions that were incomplete at the time of crash.
  ক

  Analysis pass

  খ

  Redo pass

  গ

  Undo pass

  ঘ

  None of the mentioned
• __________ 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.
  ক

  Analysis pass

  খ

  Redo pass

  গ

  Undo pass

  ঘ

  None of the mentioned
• ___________ 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.
  ক

  Analysis pass

  খ

  Redo pass

  গ

  Undo pass

  ঘ

  None of the mentioned
• The __________________ contains a list of pages that have been updated in the database buffer.
  ক

  Dirty page table

  খ

  Page table

  গ

  Dirty redo

  ঘ

  All of the mentioned
• There are special redo-only log records generated during transaction rollback, called _________ in ARIES.
  ক

  Compensation log records

  খ

  Read log records

  গ

  Page log records

  ঘ

  Redo log records
• Whenever an update operation occurs on a page, the operation stores the LSN of its log record in the _______ field of the page.
  ক

  LSN

  খ

  ReadLSN

  গ

  PageLSN

  ঘ

  RedoLSN
• __________ scheme that records only information about dirty pages and associated information and does not even require of writing dirty pages to disk.
  ক

  Fuzzy logic

  খ

  Checkpoints

  গ

  Fuzzy-checkpoint

  ঘ

  Logical checkpoint
• ______________ is used to minimize unnecessary redos during recovery.
  ক

  Dirty page table

  খ

  Page table

  গ

  Dirty redo

  ঘ

  All of the mentioned
• ARIES supports ___________ operations, which are physical in that the affected page is physically identified, but can be logical within the page.
  ক

  Physiological redo

  খ

  Physiological undo

  গ

  Logical redo

  ঘ

  Logical undo
• ARIES uses a ___________ to identify log records, and stores it in database pages.
  ক

  Log sequence number

  খ

  Log number

  গ

  Lock number

  ঘ

  Sequence