Buffer Management MCQ

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

• The operating system reserves space on disk for storing virtual-memory pages that are not currently in main memory; this space is called
  ক

  Latches

  খ

  Swap Space

  গ

  Dirty Block

  ঘ

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

  Latches

  খ

  Swap Space

  গ

  Dirty Block

  ঘ

  None of the mentioned
• Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing them in a non-two-phase manner does not have any implications on transaction serializability. This is
  ক

  Latches

  খ

  Swap Space

  গ

  Dirty Block

  ঘ

  None of the mentioned
• The ___________ policy, allows the system to write modified blocks to disk even if the transactions that made those modifications have not all committed.
  ক

  Force

  খ

  No-force

  গ

  Steal

  ঘ

  No-steal
• ______________ policy allows multiple updates to accumulate on a block before it is output to stable storage, which can reduce the number of output operations greatly for frequently updated blocks.
  ক

  Force

  খ

  No-force

  গ

  Steal

  ঘ

  No-steal
• The _______________ policy, allows a transaction to commit even if it has modified some blocks that have not yet been written back to disk.
  ক

  Force

  খ

  No-force

  গ

  Steal

  ঘ

  No-steal
• Writing the buffered log to __________ is sometimes referred to as a log force.
  ক

  Memory

  খ

  Backup

  গ

  Redo memory

  ঘ

  Disk
• Before a block of data in main memory can be output to the database, all log records pertaining to data in that block must have been output to stable storage. This is
  ক

  Read-write logging

  খ

  Read-ahead logging

  গ

  Write-ahead logging

  ঘ

  None of the mentioned
• The order of log records in the stable storage ____________ as the order in which they were written to the log buffer.
  ক

  Must be exactly the same

  খ

  Can be different

  গ

  Is opposite

  ঘ

  Can be partially same
• In order to reduce the overhead in retrieving the records from the storage space we use
  ক

  Logs

  খ

  Log buffer

  গ

  Medieval space

  ঘ

  Lower records