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

Answer: C

Computer Science & Information Technology

You might also like to view...

To make a presentation size smaller, ________ the pictures

Fill in the blank(s) with correct word

Computer Science & Information Technology

Which log is created during installation of Windows 7 to record information about the user directory structure, including security identifiers (SIDS)?

a. miglog.xml b. setupact.log c. setupapi.dev.log d. setupapi.app.log

Computer Science & Information Technology