SQL Server Locks Question:

Download Job Interview Questions and Answers PDF

What is a live lock?

MS SQL Server Locks Interview Question
MS SQL Server Locks Interview Question

Answer:

When a request for exclusive lock is denied again and again because a series of overlapping shared locks are interfering with each other and to adapt from each other they keep on changing the status, it is known as live lock.

Download MS SQL Server Locks Interview Questions And Answers PDF

Previous QuestionNext Question
What is a dead lock?What is SQL Server locking?