SQL Server Locks Question:

What is a live lock?

Tweet Share WhatsApp

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 PDF Read All 16 MS SQL Server Locks Questions
Previous QuestionNext Question
What is a dead lock?What is SQL Server locking?