Ask a Question

Which of the following is the block that is not permitted to be written back to the disk?

in Education by
Which of the following is the block that is not permitted to be written back to the disk? (a) Dead code (b) Read only (c) Pinned (d) Zapped The question was posed to me in an online interview. The query is from Lock-Based Protocols in division Concurrency Control of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
The correct answer is (c) Pinned The best explanation: A block that is not permitted to be written back to the disk is called pinned.

Related questions

0 votes
Q: A block that is not allowed to be written back to disk is said to be ______________
    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
Q: 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
    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
Q: The _______________ policy, allows a transaction to commit even if it has modified some blocks that have not yet been written back to disk.
    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
Q: Which of the following is used to determine, if a piece of data in cache needs to be written back to cache?
    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
Q: A __________ is the smallest unit of information that can be read from or written to the disk.
    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
Q: There are “record-once” versions of the compact disk and digital video disk, which can be written only once; such disks are also called __________ disks.
    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
Q: Which level of RAID refers to disk mirroring with block striping?
    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
Q: Which level of RAID refers to disk mirroring with block striping?
    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
Q: 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 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
Q: ________ is an attack technique occurs when excess data gets written to a memory block.
    ________ 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
Q: To perform logical redo or undo, the database state on disk must be operation ___________ that is, it should not have partial effects of any operation.
    To perform logical redo or undo, the database state on disk must be operation ___________ that is, it ... Undo Operations topic in chapter Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: c) A computer system was designed to have a good latest processor and I/Odevices, however the designer of the computer did not put any RAM in it.The computer does have a hard disk of 1 tera-byte. Will this computer be
    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
Q: numbers.4. (a) When running a particular program with Nmemory accesses, a computer with a cacheand paged virtual memory generates atotal of M cache misses and F page faults.Ti is the time for a cache hit; T2 is thetime for a main memory hit and T3 is thetime to load a page into main memoryfrom the disk.(i) What is the cache hit ratio ?(ii) What is the main memory hit ratio ?That is, what percentage of mainmemory accesses do not generate apage fault?(iii) What is the overall effective accessOtime for the system ?
    numbers. 4. (a) When running a particular program with N memory accesses, a computer with a cache and paged ... the system ? cribe Select the correct answer from above options...
asked Nov 26, 2021 in Education by JackTerrance

© Copyright 2018-2023 www.Blogmepost.com. All rights reserved. Developed by Blogmepost.

...