Which of the following occurs when two connections need access to same piece of data concurrently and the meanwhile another is blocked because at a particular time, only one connection can have access?
(a) Lock
(b) Block
(c) Deadlock
(d) Exclusive lock
I got this question in a job interview.
Query is from Blocking in chapter Performance Tuning and Optimization of SQL Server