Which of the Following Is a Guideline to Follow That

Multiple Choice

Which of the following is a guideline to follow that can help you avoid blocking locks and deadlocks?

A) use queries that perform multiple locks
B) use random sequences to perform multiple-table updates
C) use clustered indexes for frequently accessed tables
D) use a single query to modify a large number of rows, if possible