DataBase Management System › Keys in DBMS MCQ › Question #2630
MCQ Single Best Answer Not Set

QThe situation where the lock waits only for a specified amount of time for another lock to be released is

ID: #2630 Keys in DBMS MCQ 6,193 views
Question Info
#2630Q ID
Not SetDifficulty
Keys in DBMS MCQTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • A Lock timeout ✔ ✖
  • B Wait-wound ✔ ✖
  • C Timeout ✔ ✖
  • D Wait ✔ ✖
Correct Answer: Option A

Explanation

The timeout scheme is particularly easy to implement, and works well if transactions are short and if longwaits are likely to be due to deadlocks.
 Continue Practice
Previous Question No Next
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in th A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in tha Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key? Which one of the following attribute can be taken as a primary key? The subset of super key is a candidate key under what condition? A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is uni Which one of the following cannot be taken as a primary key ? The ______ is the one in which the primary key of one relation is used as a normal attribute in another relati The relation with the attribute which is the primary key is referenced in another relation. The relation which