DBMS Practice Test: Normalization and Transactions

Casual Mode - Take your time!

1 / 17
Correct
0
Incorrect
0
Score
0%
Multiple Choice

In a particular schedule, transaction T2 reads a value previously written by transaction T1 and transaction T3 reads a value previously written by T2. Which of the following ensures the schedule to be cascade less schedule?

  1. T1 commits before T2 and T2 commits before T3.
  2. T1 commits after T2 and T2 commits before write operation of T3.
  3. T1 commits before T2 and T2 commits before write operation of T3.
  4. T1 commits at last and T2 and T3 can commit in any order.
Change Mode