Which of the following allows non repeatable read in JDBC, connection class?

A) TRANSACTION_READ_UNCOMMITTED
B) TRANSACTION_READ_ COMMITTED
C) TRANSACTION_SERIALIZABLE
D) TRANSACTION_REPEATABLE_READ.
Explanation: A non-repeatable read is where one transaction reads a row, a second transaction alters or deletes the row, and the first transaction re-reads the row,getting different values the second time.

Interview Candidate
Dec 10th, 2005
13
13787

JDBC

Answer

Showing Answers 1 - 13 of 13 Answers

deepak agrawal

Sep 23rd, 2006

C) TRANSACTION_SERIALIZABLED) TRANSACTION_REPEATABLE_READ

pannapurneswar

Apr 16th, 2007

I think the question is which isolation levels allows non repeatable read ..the answer is
TRANSACTION_READ_UNCOMMITED
TRANSACTION_READ_COMMITED

TRANSACTION_REPEATABLE_READ only allows PHANTOM read that to if it is table level
and TRANSACTION_SERIALIZABLE doesn't allow any
Thnx