Deadlocks MCQ

Test your knowledge with important Deadlocks MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30+ more Deadlocks MCQs on Bissoy. Bissoy App

• __________ rollback requires the system to maintain additional information about the state of all the running transactions.
  ক

  Total

  খ

  Partial

  গ

  Time

  ঘ

  Commit
• Selecting the victim to be rollbacked to the previous state is determined by the minimum cost. The factors determining cost of rollback is
  ক

  How long the transaction has computed, and how much longer the transaction will compute before it completes its designated task

  খ

  How many data items the transaction has used

  গ

  How many more data items the transaction needs for it to complete

  ঘ

  All of the mentioned
• A deadlock exists in the system if and only if the wait-for graph contains a ___________
  ক

  Cycle

  খ

  Direction

  গ

  Bi-direction

  ঘ

  Rotation
• The deadlock in a set of a transaction can be determined by
  ক

  Read-only graph

  খ

  Wait graph

  গ

  Wait-for graph

  ঘ

  All of the mentioned
• The situation where the lock waits only for a specified amount of time for another lock to be released is
  ক

  Lock timeout

  খ

  Wait-wound

  গ

  Timeout

  ঘ

  Wait
• 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
  ক

  Wait-die

  খ

  Wait-wound

  গ

  Wound-wait

  ঘ

  Wait
• 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
  ক

  Wait-die

  খ

  Wait-wound

  গ

  Wound-wait

  ঘ

  Wait
• What are the ways of dealing with deadlock?
  ক

  Deadlock prevention

  খ

  Deadlock recovery

  গ

  Deadlock detection

  ঘ

  All of the mentioned
• The deadlock state can be changed back to stable state by using _____________ statement.
  ক

  Commit

  খ

  Rollback

  গ

  Savepoint

  ঘ

  Deadlock
• A system is in a ______ state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set.
  ক

  Idle

  খ

  Waiting

  গ

  Deadlock

  ঘ

  Ready