Database Fundamentals — Question 136

JDBC API 2.0 defines five levels of transaction isolation for database concurrency control.
Which of the following is the lowest level of transaction isolation?

Answer options

• A. TRANSACTION_SERIALIZABLE
• B. TRANSACTION_NONE
• C. TRANSACTION_READ_COMMITTED
• D. TRANSACTION_READ_UNCOMMITTED
• E. TRANSACTION_REPEATABLE_READ

Correct answer: B

Explanation

The correct answer is B, TRANSACTION_NONE, as it indicates no transaction isolation is applied, allowing for the highest level of concurrency but the lowest level of data consistency. The other options represent higher levels of isolation that impose stricter controls on how transactions interact with each other, which can lead to reduced concurrency.