🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← All topics

Quiz: Transactions and ACID: questions with answers

10 questions, each with the answer and a short explanation.

Take the timed quiz + get a certificate →
  1. Q1. Which ACID property ensures "all or nothing"?
  2. Q2. Data committed just before a power failure is still there after restart. Which property?
  3. Q3. Reading another transaction's UNCOMMITTED change is called a:
  4. Q4. Which isolation level prevents dirty, non-repeatable AND phantom reads?
  5. Q5. What does ROLLBACK do?
  6. Q6. Inside a long transaction you want to undo only the last few statements, not everything. What do you use?
  7. Q7. T1 and T2 both read a balance of 500, both add 100, and both write 600. Which problem is this?
  8. Q8. T1 runs SELECT COUNT() FROM orders WHERE amount 1000 twice and gets 5, then 6, because T2 inserted a row in between. This is a:
  9. Q9. Which ACID property is protected when a CHECK constraint stops a balance from becoming negative?
  10. Q10. What is a good way to reduce deadlocks?