What do you mean by Deadlock?
Hi,
deadlock is a situation in which two or more transactions are waiting for one another to give up locks. when two processes are request to the one lock of the one piece of data, attempt to acquire a lock on the others piece. so ofcourse Each process would wait for the realease the lock, unless one of the user processes is terminated.
Thanks,
Ads