DataBase Management System → Keys in DBMS MCQ → MCQ Details
MCQ Practice Single Best Answer Topic: Keys in DBMS MCQ

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

Question ID
#2630
Subchapter
Keys in DBMS MCQ
Action
Choose one option below

Choose Your Answer

Click an option to check whether your answer is correct.

  • A Lock timeout ✔ ✖
  • B Wait-wound ✔ ✖
  • C Timeout ✔ ✖
  • D Wait ✔ ✖
Correct Answer: 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.

Related Topics

Explore more questions from similar topics.

Database Basic Database Concepts MCQs DBMS Data Models Keys in DBMS MCQ Normal Form MCQ RDBMS Relational Algebra and Calculus Relational Model in DBMS SQL MCQs Structured Query Language

Share This Question

Share this MCQ with your friends or study group.