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
- 47901 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
Why do we use trigger?
What is the difference between executequery () and executeupdate ()?
How to create an multi-statement table-valued function?
What are acid properties of transaction?
What is self contained multi valued query?
query processing
What is tempdb database? : SQL Server Architecture
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is the difference between Stored Procedures and triggers?
What is function of CUBE ?
Define self join in sql server joins?
What is table join?
Why we need sql server?
How to set a database state to offline in ms sql server?
What is an execution plan?
