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
What is logon trigger?
What do you mean by SQL injection attack?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
How to delete an existing database user?
Explain mixed authentication mode of sql server?
Explain log shipping?
What is nested transaction?
In case you have filters in your report, when filters will be applied in cached report instance?
Is it possible to update the views? If yes, how, if not, why?
In what version of sql server were synonyms released?
What are different types of schemas?
Give main differences between "Truncate" and "Delete".
Can binary strings be converted into numeric or float data types?
What is a field name?
What are the types of resultset?