Database Buffer - DBMS

1.

The subsystem responsible for the allocation of buffer space is called the ___________.

   A.) Buffer
   B.) Buffer manager
   C.) Storage
   D.) Secondary storage

Answer: Option 'B'

Buffer manager

2.

In case the buffer manager do not write the blocks properly then the buffer manager uses

   A.) Replacement strategy
   B.) Forced strategy
   C.) Crash recovery system
   D.) Both a and b

Answer: Option 'C'

Crash recovery system

3.

A block that is not allowed to be written back to disk is said to be _____________

   A.) Pinned
   B.) Forced
   C.) Buffer
   D.) All of the mentioned

Answer: Option 'A'

Pinned

4.

The frequently used buffer replacement strategy is

   A.) Most recently used
   B.) Longest block
   C.) Least recently used
   D.) All of the mentioned

Answer: Option 'C'

Least recently used

5.

A major goal of the database system is to minimize the number of block transfers between the disk and memory. This is achieved by

   A.) Buffer
   B.) Catalog
   C.) Storage
   D.) Secondary storage

Answer: Option 'A'

Buffer

Database Buffer - DBMS Download Pdf