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
- 48176 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
How to verify a user name with sqlcmd tool?
What is difference between views and tables?
Explain the difference between cross join and full outer join?
How to use subqueries with the exists operators in ms sql server?
What are acid properties of transaction?
How fixed length strings are truncated and padded?
What is the use of nvl work?
What are trace files?
What is the difference between char and varchar2 datatype in sql?
How to update values in a table with update statements in ms sql server?
What is view in sql?
What is a view and what are its advantages?
Does a sql server 2005 select statement require a from?
How to make a remote connection in a database?
Do you know what is sql service broker?
