Metadata
Technology & Computer Science Undergraduate Remember Medium
Metadata
  • 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.
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.