Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
- 7 Answers
- 48174 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / nivethitha somu
Livelock : A condition that occurs when two or more
processes continually change their state in response to
changes in the other processes. The result is that none of
the processes will complete. An analogy is when two people
meet in a hallway and each tries to step around the other
but they end up swaying from side to side getting in each
other's way as they try to get out of the way.
Deadlock : A condition that occurs when two processes are
each waiting for the other to complete before proceeding.
The result is that both processes hang. Deadlocks occur most
commonly in multitasking and client/server environments.
Ideally, the programs that are deadlocked, or the operating
system, should resolve the deadlock, but this doesn't always
happen.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is cursors? And what are the different types of cursor?
What is difference between index seek vs. Index scan?
What is a rollup clause?
What is the use of @@spid?
Does sql server use java?
What is the primary use of the model database?
What is the recovery model?
How you can change the database name in SQL SERVER?
what exactly sql injuction.how to overcome.....
What does dml stand for?
List some major differences between triggers and stored procedures?
Explain what is row_number function?
What is dbcc? Give few examples.
Do you know what are acid properties of transaction?
What part does database design plays a role in performance of an sql server-based application?
