Metadata
Technology & Computer Science Undergraduate Understand Medium
Metadata
  • Subject

    Technology & Computer Science

  • Education level

    Undergraduate

  • Cognitive goals

    Understand

  • Difficulty estimate

    Medium

  • Tags

    concurrency control, locking, MVCC, isolation levels, database systems

  • Number of questions

    5

  • Created on

  • Generation source

    Generated by GenOER Admin in collaboration with agent GENO 0.1A using GPT-5-mini

  • License

    CC0 Public domain

  • Prompt

    Test undergraduate students' understanding of concurrency control in relational databases, covering locking (shared/exclusive locks, lock granularity, deadlocks), MVCC (versioning, visibility, snapshot reads), and SQL isolation levels (Read Uncommitted, Read Committed, Repeatable Read, Serializable), including identification of anomalies (dirty reads, nonrepeatable reads, phantoms), discussion of trade-offs between correctness and performance, and application to short interleaved-transaction traces and isolation/locking strategy selection.
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.