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
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
how many triggers you can have on a table? : Sql server database administration
How to enter unicode character string literals in ms sql server?
What do you know about system database? : SQL Server Architecture
Differentiate between truncate vs delete in mssql?
Explain trigger classes i.e. Instead of and after trigger?
What is a full text index?
What is sql view?
Can you tell me about the concept of ER diagrams?
What is equi join with example?
What are different backups available in sql server?
Scalability, Availability, Integration with internet, etc.)?
What is the difference between dropping a database and taking a database offline?
What is triggers in ms sql server?
How can we rewrite sub-queries into simple select statements or with joins?