Home » Interview » Technology

What do you mean by a deadlock?

Correct Answer: - When two processes are waiting to update the rows of a table which are locked by another process, the situation is called a deadlock - The reasons for it to happen are: * lack of proper row lock commands * Poor design of front-end application - It reduces the performance of the server severely - These locks get automatically released automatically when a commit/rollback operation is performed or any process is killed externally

← Previous Question Next Question→

Discussion & Comments

No comments yet. Be the first to comment!
Join Discussion