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

1 Answer

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

Related questions

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
    There are situations in which it is necessary to write back the block to disk, even though the buffer ... Buffer in chapter Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
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
    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
    A __________ is the smallest unit of information that can be read from or written to the disk. (a) ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    If no header is specified, the block is said to be an _______________ PL/SQL block. (a) Strong (b ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Which of the following is used to determine, if a piece of data in cache needs to be written back to cache? (a)Valid Bit = 0 (b)Dirty Bit = 1 (c)Valid Bit = 1 (d)Dirty Bit = 0...
asked Oct 6, 2020 in Technology by JackTerrance
0 votes
    There are record-once versions of the compact disk and digital video disk, which can be written only once ... Media in portion Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    Which level of RAID refers to disk mirroring with block striping? (a) RAID level 1 (b) RAID level ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    Which level of RAID refers to disk mirroring with block striping? (a) RAID level 1 (b) RAID level ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education 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
    ________ is an attack technique occurs when excess data gets written to a memory block. (a) Over buffering (b) ... Security questions and answers pdf, mcq on Cyber Security pdf,...
asked Nov 4, 2021 in Education by JackTerrance
0 votes
0 votes
    ______________ partitions data and parity among all N+1 disks, instead of storing data in N-disks and ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
...