What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
- 7 Answers
- 46553 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
What is an example of a primary key?
How to transfer data from a cursor to variables with a "fetch" statement?
How to list all user defined functions in the current database?
What should be the fill factor for indexes created on tables? : sql server database administration
What is the significance of null value and why should we avoid permitting null values?
Detail about the hardware which is supported by SQL server?
What is bcp? When does it used?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What are the security related catalog views? : sql server security
Does partitioning improve performance sql server?
How to insert multiple rows with a subquery?
What do we have to check in database testing?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is cursor in ms sql server?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
