Metadata
Technology & Computer Science Undergraduate Understand Medium-
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.
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%
Mock data used for demo purposes.