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
Explain user defined functions?
Explain cursor as data base object?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What is a data source file?
What is the New in SQL server 2008?
How to replace the Query Result 'Null Value' with a text ?
Explain filtered indexes benefits?
How to include text values in sql statements?
What do you understand by a view? What does the with check option clause for a view do?
Explain Geometry datatype in sql server 2008 with example
Explain sub-query?
How would we use distinct statement? What is its use?
What is difference between materialized view and view?
What is default port number for sql server 2000?
Explain the steps to create and execute a user-defined function in the sql server?