A lock that allows concurrent transactions to access different rows of – McqOptions

MCQOPTIONS

1.	A lock that allows concurrent transactions to access different rows of the same table is known as a
A.	Field-level lock
B.	Row-level lock
C.	Table-level lock
D.	Database-level lock
Answer» B. Row-level lock

Discussion

No Comment Found

Related MCQs

<p>Who detects the failure of the system and restore the database to consistent state ?</p>
<p>Which phage always carries a small piece of E.coli genome?</p>
<p>Which of the following are functions of Database Manager ?<br> <br> 1. Interacting with File Manager<br> 2. Creating Queries to Access data<br> 3. Security Enforcement<br> 4. Database Definition and Schema Generation</p>
<p>Transaction management ensures ____________ and __________ properties.</p>
<p>___________ is an interface between low level database and application program.</p>
<p>A transaction may not always complete its execution successfully. Such a transaction is termed</p>
<p>Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction?</p>
<p>What are the Svedberg values for the subunits of the 70S ribosomes of E. colli?</p>
<p>When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp smaller than that of Tj (that is, Ti is older than Tj ). Otherwise, Ti is rolled back (dies). This is</p>
<p>The deadlock state can be changed back to stable state by using _____________ statement.</p>