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
You might also like to view...
In a producer/consumer relationship, when a consumer finds the buffer empty or finds that the previous data has already been read, the consumer should call __________.
a. lock b. signal c. sleep d. await.
In a _______ diagram, circles are used to represent states.
A. state B. tape C. unary D. binary
Which of the following would be the best reason to use the Blank Report tool?
a. Quickest method to create a complicated design b. All fields need to be in the report c. Few data fields are needed. d. Controls how data is grouped and sorted.
In the Internet world, most certificates follow the LDAP standard defined in RFC 2459 by IETF.
Answer the following statement true (T) or false (F)