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 do I create a trace in sql server?
What is index in an assignment?
Which is the main third-party tool used in sql server?
What are the new features of sql server 2008 r2 reporting service?
Write a sql query to get zero records from a table having n number of records?
What is constraints and its types?
What are out-of-range errors with date and time literals?
You schedule a job to run every minute what will happen if the first job runs more than 1 min? Will the second instance of the job start?
How to retrieve field values using mssql_result()?
Explain the difference between HTTP and HTTPS in database?
What do you understand by SQL*Net?
Explain magic tables in sql server?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Does partitioning improve performance?
What do we have to check in database testing?