Chapter 6, Problem 6.17RQ

Explanation of Solution

Deadlock:

• Deadlock occurs when the requested data is being used by multiple users, this specifies that two or more users trying to access a data that is being currently utilized by some other user.
• It generally occurs in a situation when one is waiting for the resource for an indefinite period of time. But eventually, that resource is waiting for another event to occur. This problem is called as deadlock.
• It will occur when multiple transactions locked the same resources and each of the transaction is waiting for the unlocking moment of the resource.

There are two ways of managing deadlocks, which are as given below:

• The deadlock situation can be prevented once before it occurs or it can be resolved once it has occurred.
• The below indicates how the deadlock situation can be prevented and resolved in detail:

Deadlock Prevention:

• Deadlock can be prevented by making the user to request the locks that are necessary at a particular time such that it ensures that data is either accessed or it will be avoided completely.
• The access order of the resources is being set which ensures that the data requested will be available at the time of request...