SQL Server Database Administrator Question:
Download Job Interview Questions and Answers PDF
Tell me what is blocking and how would you troubleshoot it?
Answer:
Blocking happens when one connection from an application holds a lock and a second connection requires a conflicting lock type. This forces the second connection to wait, blocked on the first.
Download SQL Server DB Administrator Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What purpose does the model database serve? | Do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? |