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
- 47697 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / soma
transaction is said to be in the state of live-lock if it
cannot proceed for a indefinite period of time while the
other transaction in the system continue normally. this may
occur if the waiting scheme for lock item is unfair giving
priority to some other transaction.
deadlock: is a situation where two or more transaction are in
a simultaneous wait sate,each of them wait for the other to
release a lock before it can proceed.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How except clause is differs from not in clause?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
Can you explain various data region available in ssrs with their use?
Differentiate between sql temp table vs table variable?
What is logshipping and its purpose?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
What is the security principal at the database level that represents your session?
What does set rowcount do?
How is table type constraint applied to a table?
What are the 3 types of schema?
What are the different subsets of sql?
What is sql server query analyzer?
How do I start and stop sql server?
What is database mirroring?
What is named query? : sql server analysis services, ssas
