R4R
Right Place For Right Person TM

What do you mean by Live Lock?

previous previous previous
Question:
What do you mean by Live Lock?

Question:What do you mean by Live Lock?


Answer
A livelock is a single lock which is bassically work on the request for an exclusive lock is repeatedly denied because a series of overlapping shared locks keeps interfering. A livelock also occurs when read transactions monopolize a table or page, forcing a write transaction to wait indefinitely. When four denials are cmplete then SQL Server detects the situation and refuses further shared locks.

By:UMANG
Date:

What do you mean by Live Lock?

Post Your Answers


User Name:
Answers:

Related Links

  1. What is the Referential Integrity?
  2. What is the purpose of UPDATE STATISTICS?
  3. What is the use of SCOPE_IDENTITY() function?
  4. How do you transfer data from text file to database (other than DTS)?
  5. What is DTC?
  6. What is DTS?
  7. What are defaults? Is there a column to which a default can't be bound?
  8. What do you mean by COLLATION?
  9. When do you use SQL Profiler?
  10. What is a Join in SQL Server?
  11. What is database replication? What are the different types of replication you can set up in SQL Server?
  12. What do you mean by Distributed partitioned views.?
  13. How many New Data types are in the SQL Server 2000?
  14. What do you mean by INSTEAD OF and AFTER Triggers.?
  15. What do you mean by Cascading Referential Integrity Constraints?
  16. Whay do you mean by XML Support in Sql Server 2000?
  17. What do you mean by Indexed Views>
  18. Why we use Stored Procedure?
  19. What is the use of union in Indexing?
  20. What is the basic difference between a join and a union?
  21. What is a Cartesian product?
  22. What do you mean by Read Uncommitted?
  23. What do you mean by Read Committed?
  24. What do you mean by Repeatable Read?
  25. What do you mean by Serialized?
  26. What is RAID and what are different types of RAID configurations?
  27. Discuss about Disadvantages of cursors?
  28. What does COMMIT do?
  29. What is Oracle locking?
  30. What Oracle lock modes do you know?
  31. What is query optimization?
  32. What are the main components of Database management systems software.
  33. What are the main attributes of database management system?
  34. What databases do you know?
  35. In what sequence SQL statement are processed?
  36. Describe TO_DATE function?
  37. What is the Sql Wild card?
  38. Class members
  39. What is use of 'in' command?
  40. I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?

Question:What do you mean by Live Lock?

Back Home Next

New Updates

Topics

Topics

R4R
R4R
R4R
R4R
R4R
R4R
R4R
R4R