When transaction Ti requests a data item currently held by Tj , Ti is – McqOptions

MCQOPTIONS

1.	When transaction Ti requests a data item currently held by Tj , Ti is allowed to wait only if it has a timestamp larger than that of Tj (that is, Ti is younger than Tj ). Otherwise, Tj is rolled back (Tj is wounded by Ti ). This is
A.	Wait-die
B.	Wait-wound
C.	Wound-wait
D.	Wait
Answer» D. Wait

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>