Which of the following design strategy can reduce the occurrence of blocking locks ?

Question

TuteeHUB · Accepted Answer

Use clustered indexes on less-usage tables

TuteeHUB · Answer

Use non-clustered indexes on high-usage tables

TuteeHUB · Answer

Use clustered indexes on high-usage tables

TuteeHUB · Answer

Make sure that CREATE and DROP statements use an existing index

1.	Which of the following design strategy can reduce the occurrence of blocking locks ?
A.	Use non-clustered indexes on high-usage tables
B.	Use clustered indexes on high-usage tables
C.	Use clustered indexes on less-usage tables
D.	Make sure that CREATE and DROP statements use an existing index
Answer» C. Use clustered indexes on less-usage tables

Discussion