What do you understand by the term deadlock in DBMS

What do you understand by the term deadlock in DBMS? How can it be avoided? How can it be solved once it happens?

E

Expert

Verified

Deadlock happens if two transactions are each waiting on a resource that the other transaction holds. Deadlock can be solved by requiring transactions to acquire all locks at the same time; once it happens, the only way to treat it is to abort one of the transactions and back out of partially completed work.

   Related Questions in Database Management System

©TutorsGlobe All rights reserved 2022-2023.