Deadlock Handling MCQ

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

• Which of the following steps must be taken while choosing a victim?
  ক

  Avoiding starvation

  খ

  Number of transactions involved in rollback

  গ

  Data items used by the transaction

  ঘ

  All of the mentioned
• State true or false: Partial rollback is not possible.
  ক

  True

  খ

  False
• How do we generally recover from a deadlock?
  ক

  By aborting all the transactions

  খ

  By rolling back all the transactions

  গ

  By rolling back only a selected number of transactions

  ঘ

  None of the mentioned
• The _________ graph describes deadlocks precisely
  ক

  Wound wait graph

  খ

  Wait die graph

  গ

  Wait for graph

  ঘ

  None of the mentioned
• Lock timeouts have which of the following advantages?
  ক

  Unnecessary rollbacks do not occur

  খ

  Transactions do not starve

  গ

  It is easy to implement

  ঘ

  All of the mentioned
• State true or false: Wait die scheme is a non-preemptive technique
  ক

  True

  খ

  False
• Deadlocks can be prevented using
  ক

  Preemption and transaction rollbacks

  খ

  Wait and die scheme

  গ

  Wound-wait scheme

  ঘ

  All of the mentioned
• Which of the following is not a method in deadlock handling
  ক

  Deadlock prevention

  খ

  Deadlock detection

  গ

  Deadlock recovery

  ঘ

  Deadlock distribution
• A system is in a _______ state if there exists a set of transactions in which every transaction is waiting for another transaction in the set.
  ক

  Deadlock

  খ

  Starved

  গ

  Isolated

  ঘ

  None of the mentioned