in Education by
A condition that occurs when two transactions wait for each other to unlock data is known as a(n) (a) Shared lock (b) Exclusive lock (c) Binary lock (d) Deadlock This question was addressed to me by my school teacher while I was bunking the class. This interesting question is from Multiversion Schemes in chapter Concurrency Control of Database Management

1 Answer

0 votes
by
Right answer is (d) Deadlock Easy explanation - Deadlock occurs when two transactions wait for each other to unlock data.

Related questions

0 votes
    Each of a pair of transactions has read data that is written by the other, but there is no data ... Answers, Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    If M and N are any two events, the probability that at least one of them occurs is A. P (M) + P (N) - 2 P (M ∩ ... P (N) + 2P (M ∩ N) Select the correct answer from above options...
asked Nov 20, 2021 in Education by JackTerrance
0 votes
    If M and N are any two events, then the probability that exactly one of them occurs is A. P(A)+P(B)-2p(A∩B) B. P( ... )-2P( ˉ A ∩ ˉ B ) Select the correct answer from above options...
asked Nov 16, 2021 in Education by JackTerrance
0 votes
    If M and N are any two events, then the probability that exactly one of them occurs is A. P ( M ) + P ( N ) − 2 P ... + 2 P ( M ∩ N ) P Select the correct answer from above options...
asked Nov 15, 2021 in Education by JackTerrance
0 votes
    If M and N are any two events, then the probability that exactly one of them occurs is A. `P(M)+P(N)-2P(M cap N)` B. C. D. Select the correct answer from above options...
asked Nov 13, 2021 in Education by JackTerrance
0 votes
    A lock that allows concurrent transactions to access different rows of the same table is known as a ( ... Protocols topic in section Concurrency Control of Database Management...
asked Oct 10, 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
    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
    A bag contains n+1 coins. If is known that one of these coins shows heads on both sides, whereas the other coins ... 5 D. none of these Select the correct answer from above options...
asked Nov 15, 2021 in Education by JackTerrance
0 votes
    When activation value is determined by using the average of fluctuations of outputs from other units, it is known as? ... d) none of the mentioned Please answer the above question....
asked Aug 27, 2022 in Education by JackTerrance
0 votes
    When candidates have only the condition of age, why should they give other information to Election Commission? Please answer the above question....
asked Aug 14, 2022 in Education by JackTerrance
0 votes
0 votes
    2n boys are randomly divided into two subgroups containint n boys each. The probability that eh two tallest boys are ... none of these Select the correct answer from above options...
asked Nov 15, 2021 in Education by JackTerrance
...