in Education by
If a transaction does not modify the database until it has committed, it is said to use the ___________ technique. (a) Deferred-modification (b) Late-modification (c) Immediate-modification (d) Undo I had been asked this question in my homework. My doubt stems from Recovery topic in division Recovery System of Database Management

1 Answer

0 votes
by
The correct option is (a) Deferred-modification The best explanation: Deferred modification has the overhead that transactions need to make local copies of all updated data items; further, if a transaction reads a data item that it has updated, it must read the value from its local copy.

Related questions

0 votes
    ___________ 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
    If an transaction is performed in a database and committed, the changes are taken to the previous state ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    If database modifications occur while the transaction is still active, the transaction is said to use the ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 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 _______________ 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
    In the ___________ scheme, a transaction that wants to update the database first creates a complete copy ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    _______ means that data used during the execution of a transaction cannot be used by a second transaction ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    _______ means that data used during the execution of a transaction cannot be used by a second transaction ... Schemes topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    ________ is a technique where attackers modify legitimate software to hide a malicious application. Wipers Exploits Code caves Weaponized documents...
asked Oct 25, 2020 in Technology 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
    If transaction Ti gets an explicit lock on the file Fc in exclusive mode, then it has an ... Based Protocols topic in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    A lock that prevents the use of any tables in the database from one transaction while another ... Multiversion Schemes in section Concurrency Control of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    A field has zero divergence and it has curls. The field is said to be (a) Divergent, ... theory proposed by,electromagnetic theory engineering physics,electromagnetic theory nptel...
asked Nov 11, 2021 in Education by JackTerrance
...