Ask a Question

The ___________ policy, allows the system to write modified blocks to disk even if the transactions that made those modifications have not all committed.

in Education by
The ___________ policy, allows the system to write modified blocks to disk even if the transactions that made those modifications have not all committed. (a) Force (b) No-force (c) Steal (d) No-steal The question was posed to me in my homework. I'd like to ask this question from Buffer Management in section Recovery System 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
Correct answer is (c) Steal The best explanation: The no-steal policy does not work with transactions that perform a large number of updates.

Related questions

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: _____ is a process of verifying transactions, bundling them into blocks, and adding those blocks to the blockchain.
    _____ is a process of verifying transactions, bundling them into blocks, and adding those blocks to the blockchain. A. Mining B. Digging C. Filtering D. Coding...
asked Nov 23, 2022 in Education by JackTerrance
0 votes
Q: ______________ policy allows multiple updates to accumulate on a block before it is output to stable storage, which can reduce the number of output operations greatly for frequently updated blocks.
    ______________ policy allows multiple updates to accumulate on a block before it is output to stable storage, ... Management topic in chapter Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing them in a non-two-phase manner does not have any implications on transaction serializability. This is
    Locks on buffer blocks are unrelated to locks used for concurrency-control of transactions, and releasing ... Management topic in portion Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: ___________ refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.
    ___________ refers to the ability of the system to recover committed transaction updates if either the system ... in chapter Query Processing Techniques of Database Management...
asked Oct 10, 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: If a transaction does not modify the database until it has committed, it is said to use the ___________ technique.
    If a transaction does not modify the database until it has committed, it is said to use the ___________ ... from Recovery topic in division Recovery System 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 _______ is that part of main memory available for storage of copies of disk blocks.
    The _______ is that part of main memory available for storage of copies of disk blocks. (a) Buffer ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 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: The policy suggested by Khrushchev that the US capital system and Soviet system would have to co-exist.
    State the appropriate concept for the given statement. 1. The policy suggested by Khrushchev that the US capital ... pertinent issues. Select the correct answer from above options...
asked Aug 3, 2022 in Education by JackTerrance
0 votes
Q: The ____ lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.
    The ____ lock allows concurrent transactions to access the same row as long as they require the use of ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: A lock that allows concurrent transactions to access different rows of the same table is known as a
    A lock that allows concurrent transactions to access different rows of the same table is known as a ( ... Protocols topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
    The ______ clause allows us to select only those rows in the result relation of the ____ clause that ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: __________ scheme that records only information about dirty pages and associated information and does not even require of writing dirty pages to disk.
    __________ 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

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

...