in Education by
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

1 Answer

0 votes
by
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.

Related questions

0 votes
    The _______________ policy, allows a transaction to commit even if it has modified some blocks that have ... Buffer Management in chapter Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    Which of the following is the block that is not permitted to be written back to the disk? (a) ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    A block that is not allowed to be written back to disk is said to be ______________ (a) Pinned (b) ... Buffer topic in chapter Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    In the buffer where there is no space for another block, the block can be inserted using (a) ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    I had a program working good (without prompting errors) using references, but I decided to use a pointer-to-pointer array ... that it is there because I have put two flags (cout...
asked Apr 6, 2022 in Education by JackTerrance
0 votes
    How can a nucleus lose electrons ( β β -particles) even though free electrons are not present in it? Select the correct answer from above options...
asked Jan 2, 2022 in Education by JackTerrance
0 votes
    The ___________ policy, allows the system to write modified blocks to disk even if the transactions that ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    The client expects a timely response from the service and might even block while it waits. This represents the _________ client ... B. One to one C. One to many D. Synchronous...
asked Jan 10, 2023 in Technology by JackTerrance
0 votes
    A major goal of the database system is to minimize the number of block transfers between the disk and ... Buffer in portion Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    The subsystem responsible for the allocation of buffer space is called the ___________ (a) Buffer (b) Buffer ... in section Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    __________ scheme that records only information about dirty pages and associated information and does not even require ... topic in section Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    c) A computer system was designed to have a good latest processor and I/O devices, however the designer of the ... in support of your Select the correct answer from above options...
asked Nov 28, 2021 in Education by JackTerrance
0 votes
    When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    When transaction Ti requests a data item currently held by Tj, Ti is allowed to wait only if it ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    I am trying to fit some (numpy) data into python skLearn modules, but keep getting error messages. When ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jun 3, 2022 in Education by JackTerrance
...