What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
- 7 Answers
- 45576 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / nivethitha somu
Livelock : A condition that occurs when two or more
processes continually change their state in response to
changes in the other processes. The result is that none of
the processes will complete. An analogy is when two people
meet in a hallway and each tries to step around the other
but they end up swaying from side to side getting in each
other's way as they try to get out of the way.
Deadlock : A condition that occurs when two processes are
each waiting for the other to complete before proceeding.
The result is that both processes hang. Deadlocks occur most
commonly in multitasking and client/server environments.
Ideally, the programs that are deadlocked, or the operating
system, should resolve the deadlock, but this doesn't always
happen.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
Define indexes?
Can binary strings be converted into numeric or float data types?
How to retrieve field values using mssql_result()?
What number aggregate functions are accessible there in sql?
What are the parts of a function?
What do you mean by subquery?
What is equi join with example?
What are system databases into sql server (2005/2008) : sql server database administration
How to get a list of columns using the "sys.columns" view in ms sql server?
How to Update from select query in sql server?
How to execute the cursor queries with "open" statements?
In case you have filters in your report, when filters will be applied in cached report instance?
What is the difference between function and stored procedure in sql server?
What is the difference between composite index and covering index?
What command is used to delete a table from the database in the sql server and how?
