in Education by
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 (a) Wait-die (b) Wait-wound (c) Wound-wait (d) Wait This question was addressed to me in an interview for job. This question is from Deadlocks topic in section Concurrency Control of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
Correct answer is (a) Wait-die Best explanation: The wait–die scheme is a non-preemptive technique.

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 a transaction Ti attempts to update a data item, it requests a _________ on that data item. ... Snapshot Isolation topic in chapter Concurrency Control of Database Management...
asked Oct 10, 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
    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
    A gas at 350 K and 15 bar has molar volume 20 percent smaller than that for an ideal gas under the ... attractive forces are dominant Select the correct answer from above options...
asked Jan 2, 2022 in Education by JackTerrance
0 votes
    Write a program in Java to input any age and determine whether the age is valid or  invalid. If age is ... is valid otherwise invalid. Select the correct answer from above options...
asked Dec 24, 2021 in Education by JackTerrance
0 votes
    A die is rolled. If the outcome is an odd number. What Is the probability that It is a number greater than 1. Select the correct answer from above options...
asked Nov 25, 2021 in Education by JackTerrance
0 votes
    A die is rolled. If the outcome is an even number, what is the probability that it is a number greater than 2? Select the correct answer from above options...
asked Nov 17, 2021 in Education by JackTerrance
0 votes
    A block that is not allowed to be written back to disk is said to be ______________ (a) Pinned (b) ... Buffer topic in chapter Storage and File Structures of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
    ____________ denotes the largest timestamp of any transaction that executed write(Q) successfully. (a) W- ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    A coin is tossed and then a die is rolled only in case a head is shown on the coin. Describe the sample space for this experiment. Select the correct answer from above options...
asked Nov 22, 2021 in Education by JackTerrance
0 votes
    In a _____________ operations do not wait for requests to produce tuples, but instead generate the tuples ... Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    I'm curious about manipulating time in Python. I can get the (last modified) age of a file using ... JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jul 3, 2022 in Education by JackTerrance
...