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
- 47977 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 do you understand by recursive stored procedures?
What is sparse columns of sql server 2008?
Can group functions be mixed with non-group selection fields in ms sql server?
Who is the owner of a schema in ms sql server?
can a database be shrunk with users active? : Sql server administration
What does null mean?
What encryption security is available in sql azure?
What stored by the master?
Explain having clause?
What is the difference between upgrade and migration in sql server?
How many types of cursor type are there?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What are the features of Embedded SQL
Why we use trigger in sql server with example?
How to list all tables in the database using odbc_tables()?
