in Education by
When a transaction Ti attempts to update a data item, it requests a _________ on that data item. (a) Read lock (b) Update lock (c) Write lock (d) Chain lock I had been asked this question during an online interview. The query is from Snapshot Isolation topic in chapter Concurrency Control of Database Management

1 Answer

0 votes
by
Correct choice is (c) Write lock Easiest explanation - Reads are unaffected by this, since they do not obtain locks.

Related questions

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
    The __________ requires that each transaction Ti executes in two or three different phases in its lifetime ... topic in section Concurrency Control of Database Management...
asked Oct 10, 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
    When a computer processor does not gets a data item that it requires in cache, then the problem is known as _________. (a)Write Miss (b)Cache Read (c)Cache Hit——– (d)Cache Miss...
asked Oct 6, 2020 in Technology by JackTerrance
0 votes
    _________ refers to an undesirable state when a system attempts to perform two or more operations, which should, ... condition 2. Optimistic locking 3. Locking 4. Transaction...
asked Apr 12, 2021 in Technology by JackTerrance
0 votes
    A _________ role is a virtual machine instance running the Microsoft IIS Web server that can accept and respond to HTTP or HTTPS requests. 1) Web 2) Server 3) Worker 4) Client...
asked Dec 23, 2020 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
    In a _________ the system makes repeated requests for tuples from the operation at the top of the pipeline ... topic in section Query Processing Techniques of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    The process that attempts to understand the art and science of encryption and decryption is known as __________. (1)Cryptography (2)Cryptology (3)Cryptanalysis...
asked Mar 19, 2021 in Technology by JackTerrance
0 votes
    I tested out the script below in jsfiddle and it works fine, can someone guide me how to fix it? ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Dec 31, 2021 in Education by JackTerrance
0 votes
    There are special redo-only log records generated during transaction rollback, called _________ in ARIES. (a) ... from ARIES in division Recovery System of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    What is the JavaScript code snippet to update the content of the timestamp element when the user clicks on ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Oct 23, 2021 in Education by JackTerrance
...