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
- 47991 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
What happens if ntwdblib.dll is missing on your machine?
What are the commands used in DCL?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
How to modify an existing user defined function?
What is replication with database mirroring? : sql server database administration
Explain different forms of normalization?
Why use cursor in sql server?
Explain features and concepts of analysis services?
What command must you use to include the not null constraint after a table has already been created?
Do you know how to store and query spatial data?
What is a filestream?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
How will you optimize a stored procedure optimization?
Difference between Sql server reporting services and Crystal reports?
What is the difference between join and inner join?
