Ask a Question

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

in Education by
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 (a) Latches (b) Swap Space (c) Dirty Block (d) None of the mentioned The question was asked in final exam. My question is taken from Buffer Management topic in portion Recovery System of Database Management

1 Answer

0 votes
by
Right option is (a) Latches The best explanation: These locks, and other similar locks that are held for a short duration.

Related questions

0 votes
Q: The ___________ policy, allows the system to write modified blocks to disk even if the transactions that made those modifications have not all committed.
    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
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: 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: The __________________ contains a list of blocks that have been updated in the database buffer.
    The __________________ contains a list of blocks that have been updated in the database buffer. (a) ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: All lock information is managed by a __________ which is responsible for assigning and policing the locks used by the transactions.
    All lock information is managed by a __________ which is responsible for assigning and policing the locks ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: How many techniques are available to control concurrency on B+ trees?
    How many techniques are available to control concurrency on B+ trees? (a) One (b) Three (c) Four ... in Index Structures in chapter Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: Why do we need concurrency control on B+ trees ?
    Why do we need concurrency control on B+ trees ? (a) To remove the unwanted data (b) To easily ... in Index Structures topic in division Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: In case the buffer manager do not write the blocks properly then the buffer manager uses
    In case the buffer manager do not write the blocks properly then the buffer manager uses (a) Replacement ... , 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: Applications developed by programming languages like ____ and ______ have this common buffer-overflow error.
    Applications developed by programming languages like ____ and ______ have this common buffer-overflow error. (a) C, Ruby ... questions and answers pdf, mcq on Cyber Security pdf,...
asked Nov 4, 2021 in Education by JackTerrance
0 votes
Q: How can I continue this rebase allowing unrelated histories with the forced flag introduced in the new release?
    How can I continue this rebase allowing unrelated histories with the forced flag introduced in the new release?...
asked Jan 8, 2021 in Technology by JackTerrance
0 votes
Q: ______ stores longer lived control data like component IP addresses and distributed locks.
    ______ stores longer lived control data like component IP addresses and distributed locks. (1)Bulletin Board System (2)Consul (3)NATS (4)All the options...
asked Aug 24, 2021 in Technology by JackTerrance
0 votes
Q: The name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called
    The name of the transaction file shall be provided by the operator and the file that contains the edited ... and Durability topic in section Transactions of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
Q: A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.
    A system is in a ______ state if there exists a set of transactions such that every transaction in the ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
Q: program code for this question: Raju has a lot of strings but he does not like all of them.He likes
    program code for this question: Raju has a lot of strings but he does not like all of them.He likes only Swaggy ... at least K times. Select the correct answer from above options...
asked Dec 29, 2021 in Education by JackTerrance

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

...