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
- 47969 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / swapna
Deadlock is a situation when two processes, each having a
lock on one piece of data, attempt to acquire a lock on the
other's piece. Each process would wait indefinitely for
the other to release the lock, unless one of the user
processes is terminated. SQL Server detects deadlocks and
terminates one user's process.
A livelock is one, where a request for an exclusive lock
is repeatedly denied because a series of overlapping shared
locks keeps interfering. SQL Server detects the situation
after four denials and refuses further shared locks. A
livelock also occurs when read transactions monopolize a
table or page, forcing a write transaction to wait
indefinitely
| Is This Answer Correct ? | 87 Yes | 10 No |
Post New Answer View All Answers
What is a natural primary key?
How do triggers work?
Will the writetext statement activate a trigger?
What are the reporting services components?
What are key constraints?
What is the difference between migration and upgradation in sql server?
What is the difference between Clustered and Non-Clustered Index?
Can you leave a union at any time?
What happens if you delete a table that is used by a view?
Explain the creation and execution of a user-defined function in the sql server?
What is use of except clause? How it differs from not in clause?
Is it possible to update the views? If yes, how, if not, why?
What is the recovery model? List the types of recovery model available in sql server?
Can You Use Data Mining Models In Ssrs?
What is the default order of an order by clause?
