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
- 47982 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / sanjeev kumar
Dead Lock:
Deak Lock is a situation when two or more process
continuous working and each having a lock on a particular
record but at a time only one can lock a particular and the
other one will go to dead lock
Live Lock:
A human example of live lock would be two people who meet
face-to-face in a corridor and each moves aside to let the
other pass, but they end up moving from side to side without
making any progress because they always move the same way at
the same time and never cross each other. This is good
example of live lock.
| Is This Answer Correct ? | 29 Yes | 22 No |
Post New Answer View All Answers
You want to implement the many-to-many relationship while designing tables. How would you do it?
What is difference between delete and truncate commands?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What is the difference between Normalization and De-normalization?
What are the restrictions while creating batches in sql server?
what is the difference between a primary key and a unique key? : Sql server database administration
How does Report Builder support Analysis Services cubes?
System variable and temporary variables
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
How does stuff differ from the replace function?
What are the common performance issues in sql server?
what's sql server? : Sql server database administration
Explain transaction server implicit?
Can we use trigger new in before insert?
How many ways to create table-valued functions?
