Intermediate
Database Management Systems
Q43 / 100
What is a transaction isolation level?
Correct! Well done.
Incorrect.
The correct answer is B) A setting controlling how transaction changes are visible to other concurrent transactions, balancing consistency vs. concurrency
B
Correct Answer
A setting controlling how transaction changes are visible to other concurrent transactions, balancing consistency vs. concurrency
Explanation
SQL isolation levels: READ UNCOMMITTED (dirty reads), READ COMMITTED (default, no dirty reads), REPEATABLE READ (no non-repeatable reads), SERIALIZABLE (no phantom reads). Higher isolation = lower concurrency.
Progress
43/100