Question

Which isolation level prevents dirty read in JDBC, connection class.

A) TRANSACTION_READ_UNCOMMITTED
B) TRANSACTION_READ_ COMMITTED
C) TRANSACTION_SERIALIZABLE
D) TRANSACTION_REPEATABLE_READ.
Explanation: A Dirty read allows a row changed by one transaction to be read by another transaction before any change in the row has been committed.

=============================================

Please explain with diagrams,figures and example What is this isolation level ??What happens in transaction read uncommitted?

please explain the question and solution because i am not able to understand the logic behind this

Subject: Dbms , j2ee,jdbc

Answer 1

Answer Option B: TRANSACTION_READ_ COMMITTED

Explanation:

TRANSACTION_READ_COMMITTED is the constant that dirty reads are prevented; non-repeatable reads and phantom reads can occur.

What is an isolation level?

Isolation level defines the degree to which transaction must be isolated from the data modifications made by any other in the db system.