Assess undergraduate students' understanding of concurrency control in relational databases, focusing on locking mechanisms (shared/exclusive, row/table, intent locks, two-phase locking), isolation levels (read uncommitted through serializable and the phenomena they prevent: dirty, non-repeatable, phantom reads), and deadlock detection/avoidance strategies (wait-for graphs, timeouts, wound-wait/wait-die). Questions should test conceptual knowledge, interpretation of transaction schedules, trade-offs between isolation and performance, and selection or design of appropriate deadlock resolution policies.