← 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 →- Q1. Which ACID property ensures "all or nothing"?
- Q2. Data committed just before a power failure is still there after restart. Which property?
- Q3. Reading another transaction's UNCOMMITTED change is called a:
- Q4. Which isolation level prevents dirty, non-repeatable AND phantom reads?
- Q5. What does ROLLBACK do?
- Q6. Inside a long transaction you want to undo only the last few statements, not everything. What do you use?
- Q7. T1 and T2 both read a balance of 500, both add 100, and both write 600. Which problem is this?
- 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:
- Q9. Which ACID property is protected when a CHECK constraint stops a balance from becoming negative?
- Q10. What is a good way to reduce deadlocks?