Search Interview Questions
| More than 3000 questions in repository.|
There are more than 900 unanswered questions.
Click here and help us by providing the answer.
Have a video suggestion.
Click Correct / Improve and please let us know.
|Interview Questions and Answers|
|Frequently asked to experienced developers. Recently asked in many US interviews.|
|Ans. When multiple external resources are trying to access the DB locks and runs into cyclic wait, it may makes the DB unresponsive. |
Deadlock can be avoided using variety of measures, Few listed below -
Can make a queue wherein we can verify and order the request to DB.
Less use of cursors as they lock the tables for long time.
Keeping the transaction smaller.
|Help us improve. Please let us know the company, where you were asked this question :|
|Like Discuss Correct / Improve  java   database   architecture Asked in 7 Companies expert   frequent|
|What is a Deadlock ?|
|What are the four situations that are required for deadlock to happen ?|
|What is Livelock in relation to deadlock ?|
|Write Java code that would cause deadlock ?|
|How can multi threading lead to a deadlock ?|