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

A) Use clustered indexes on less-usage tables

B) Use non-clustered indexes on high-usage tables

C) Make sure that CREATE and DROP statements use an existing index

D) Use clustered indexes on high-usage tables

Correct Answer : Use clustered indexes on high-usage tables

Explanation : Clustered index should be created on frequently used tables.

Top Trending Technologies MCQ's

Machine Learning

Artificial Intelligence

Natural Language Processing

Top Trending Technologies Interview Questions