Metadata
Technology & Computer Science Undergraduate Understand Medium-
Subject
Technology & Computer Science
-
Education level
Undergraduate
-
Cognitive goals
Understand
-
Difficulty estimate
Medium
-
Tags
[ACID, isolation levels, transactions, concurrency, databases]
-
Number of questions
5
-
Created on
-
Generation source
-
License
CC0 Public domain
-
Prompt
[Assess students' understanding of ACID properties (Atomicity, Consistency, Isolation, Durability); common isolation levels (Read Uncommitted, Read Committed, Repeatable Read, Serializable); the anomalies they prevent (dirty reads, non-repeatable reads, phantom reads); trade-offs between isolation and concurrency; and apply these concepts to short SQL transaction scenarios.]
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%
Mock data used for demo purposes.