What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
- 7 Answers
- 46552 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
what do you understand by change data capture?
What are sql servers used for?
What are the types of database schema? : sql server analysis services, ssas
What is the difference between count () and rowcount ()?
What are the types of indexing?
How to retrieve error messages using mssql_get_last_message()?
Tell me what is de-normalization and what are some of the examples of it?
How to loop through result set objects using odbc_fetch_row()?
How to set database to be read_only in ms sql server?
Explain acid?
What are the advantages of paper records?
What is nested transaction?
Explain sql server authentication modes?
‘Order by’ is not allowed in a view how can you sort information from a view?
What is a print index?
