1.

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 mentionedThe question was posed to me in an international level competition.My doubt stems from Database Buffer topic in chapter Storage and File Structures of Database Management

Answer»

Right option is (a) Pinned

To EXPLAIN: ALTHOUGH many operating systems do not support pinned blocks, such a feature is ESSENTIAL for a DATABASE system that is RESILIENT to crashes.



Discussion

No Comment Found

Related InterviewSolutions