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
- 48188 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
Is it possible to update the views? If yes, how, if not, why?
What is catalog views?
Can we join two tables without primary key?
Explain about Joins?
What is join and name different type of joins?
What are secondary xml indexes?
Which are the important points to note when multilanguage data is stored in a table?
What is inline table-value user-defined function?
How to get nth highest salary from employee table.
What is the difference between join and inner join?
Can sql server 2016 run on windows 7?
What are the advantages of sql stored procedure?
Explain multiserver query
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Explain different backup plans?
