Skills101
← All practice quizzes

Quiz: Transactions and ACID

5 questionsNo time limitPass: 60%+10 XP on first pass

Why a bank transfer must be all-or-nothing. ACID explained with an example, COMMIT and ROLLBACK, concurrency problems (dirty read, lost update), isolation levels and deadlocks.

Log in to take the quiz

Free account · see your score, answers and explanations, earn XP

  1. Question 1

    Which ACID property ensures "all or nothing"?

  2. Question 2

    Data committed just before a power failure is still there after restart. Which property?

  3. Question 3

    Reading another transaction's UNCOMMITTED change is called a:

  4. Question 4

    Which isolation level prevents dirty, non-repeatable AND phantom reads?

  5. Question 5

    What does ROLLBACK do?