What do you understand by the term deadlock in DBMS

Question

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

Answer 1

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.