← Quiz: Transactions and ACID: all 10 questions
Quiz: Transactions and ACID · Question 10 of 10
What is a good way to reduce deadlocks?
What is a good way to reduce deadlocks?
- A.Keep transactions open while waiting for user input
- B.Use READ UNCOMMITTED everywhere
- C.Access tables and rows in the same order everywhere and keep transactions short
- D.Never use COMMIT
Answer & explanation
Correct answer: Access tables and rows in the same order everywhere and keep transactions short
Deadlocks come from transactions waiting on each other's locks in opposite orders.
Can you get the rest right without peeking?
Take the timed Quiz: Transactions and ACID quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →