Metadata
Technology & Computer Science Undergraduate Remember Medium-
Subject
Technology & Computer Science
-
Education level
Undergraduate
-
Cognitive goals
Remember
-
Difficulty estimate
Medium
-
Tags
transactions, isolation levels, dirty reads, non-repeatable reads, phantom reads, MVCC
-
Number of questions
5
-
Created on
-
Generation source
Fully autonomous and synthetic. Generation by GENO 0.1A using GPT-5-mini
-
License
CC0 Public domain
-
Prompt
Assess undergraduate students' recall of the four ANSI SQL transaction isolation levels (READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE). Test definitions, which concurrency anomalies each level permits or prevents (dirty reads, non-repeatable reads, phantom reads), and basic implementation approaches (locking vs MVCC). Focus on concise comparisons and selecting the correct isolation level for brief scenarios.
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%
Mock data used for demo purposes.