What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
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
List out the difference between union and union all in sql server?
What is difference between equi join and inner join?
How to create a local temporary stored procedure?
What are clustered and non-clustered index?
Can you explain what is sql server english query?
How can a database be repaired?
How do I shrink an ldf file?
Name some of the open source software that you can use in alternative to SSR?
What are the Advantages of using CTE in sql server?
List the advantages of using stored procedures?
What is the use of floor function in sql server?
What is the largest component inside a field?
How to display a past time in days, hours and minutes?
Can a database be shrunk with users active?
Give me any three differences between Truncate and Delete.