1.

What do you mean by deadlock DBMS?

Answer»

A deadlock condition occurs when ONE task is waiting for the other work to leave the resource which it has a hold. In this current situation, none of the functions gets completed, and the work is always in the waiting state.

9. Explain the NECESSARY TECHNIQUES to control deadlocks?

There are 3 methods by which deadlocks can be handled:-

  • Deadlock Prevention:-Do not allow the condition that may LEAD to deadlock.

  • Deadlock Avoidance:- Does not accept the resource request if it can lead to deadlock

  • Deadlock Detection:-Allow the resource request but periodically checks the deadlocks. If found then one of the transaction is aborted.


Discussion

No Comment Found

Related InterviewSolutions