🎴 Flashcard Mode
DBMS Practice Test: Normalization and Transactions
Card1 / 17
Mastered0
Review0
QuestionClick to flip
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?
AnswerClick to flip back
A
T1 commits before T2 and T2 commits before T3.
💡 Explanation:
In a cascadeless schedule, transactions must commit before their dependent transactions read their data. Here T2 reads from T1, and T3 reads from T2. To ensure cascadelessness: T1 must commit before T2 reads, and T2 must commit before T3 reads. Option A correctly states this requirement.