Discussion :: SQL Server MCQs
- Point out the correct statement :
|
A.
Avoid less row count SQL statements that can cause a table lock
|
|
B.
A blocking lock occurs when one lock causes another process to wait in a holding queue
|
|
C.
Lock is a done by database when any connection access a different piece of data concurrently
|
|
D.
None of the mentioned
|
Whatsapp
Facebook
Answer : Option B
Explanation :
If blocking locks are common (rather than infrequent), there is probably some kind of design or query implementation problem.
Be The First To Comment