College Subject Practice · College Year 2
Transactions practice questions — College Subject Practice · College Year 2 Database Systems
Practise transactions with topic-based questions. Preview a sample, then start a short session.
See the question style before signup · Get instant feedback · Continue with focused practice
Try a sample question
Check your answer to see the explanation where one has been published.
Try this question
Why does the SQL Serializable isolation level prevent phantom reads while Repeatable Read (in the SQL standard) does not?
1 sample question · No signup needed
2
During crash recovery with undo/redo logging, a transaction that has a START record but no COMMIT or ABORT record in the log must be:
3
Consider the schedule: T1 reads A, T2 writes A, T1 writes A. In the precedence graph, the conflicting operations create edges that result in:
Start a sample session
50 published questions available for this topic.