Q:
What do you mean by a deadlock?
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.
View answer
Workspace
Report Error
Discuss