Skip to content
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

Something unclear? Report this question.

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.