MCQOPTIONS
Saved Bookmarks
| 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 | |