What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?
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 to check table values in sql server?
How to perform key word search in tables?
Do you know how to store and query spatial data?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is the difference between delete and truncate statements?
Do you know the isolation level that sql server support?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Explain Normalization and DE normalization
What is function of CUBE ?
How will you know when statistics on a table are obsolete?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
How do I view a stored procedure in sql server?
List the different normalization forms?
Explain different forms of normalization?
Define cursor locking