DEVFYI - Developer Resource - FYI

What is a deadlock ? Explain .

ORACLE Interview Questions and Answers (Part 1)

(Continued from previous question...)

63. What is a deadlock ? Explain .

Two processes wating to update the rows of a table which are locked by the other process then deadlock arises. In a database environment this will often happen because of not issuing proper row lock commands. Poor design of front-end application may cause this situation and the performance of server will reduce drastically.
These locks will be released automatically when a commit/rollback operation performed or any one of this processes being killed externally.

(Continued on next question...)

Other Interview Questions