Question

There are situations in which it is necessary to write back the block to disk, even though the buffer space that it occupies is not needed. This write is called the

(a) Pinned block strategy

(b) Forced output block

(c) Buffer replacement strategy

(d) All of the mentioned

I have been asked this question in semester exam.

I need to ask this question from Database Buffer in chapter Storage and File Structures of Database Management

Answer 1

The correct choice is (b) Forced output block

The best explanation: The main-memory contents and thus buffer contents are lost in a crash, whereas data on disk usually survive a crash.