A deadlock occurs when two or more sessions permanently block each other with each session having a lock on a resource, the other session is trying to lock. In this Lab, we will learn about three different types of deadlocks.
– Conversion Deadlock
– Cyclic Deadlock
– Foreign Key Deadlock
Exercise 1: Conversion Deadlock
Exercise 2: Cyclic Deadlock
Exercise 3: Foreign Key Deadlock