Question: what is the difference between lock and deadlock in oracle?
Answer: Deadlock occurs when one process is blocked and waiting for a second process to complete its work and release locks, while the second process at the same time is blocked and waiting for the first process to release the lock. ... Deadlocks can and should be prevented.