🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← 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?

  1. A.Keep transactions open while waiting for user input
  2. B.Use READ UNCOMMITTED everywhere
  3. C.Access tables and rows in the same order everywhere and keep transactions short
  4. 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 →