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
Correct Answer:
Verified
Q1: What happens to a request for a
Q3: Indexes prevent the database engine from having
Q4: Which of the following best defines a
Q5: Only one user or client application at
Q6: The % Processor Time performance counter displays
Q7: Which situation occurs when two transactions each
Q8: If a request is made to use
Q9: Which problem occurs when a concurrent process
Q10: Which of the following is true about
Q11: Which of the following is a database
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents