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

A) TRANSACTION_READ_UNCOMMITTED
B) TRANSACTION_READ_ COMMITTED
C) TRANSACTION_SERIALIZABLE
D) TRANSACTION_REPEATABLE_READ.
Explanation: A phantom read is where one transaction reads all rows that satisfy a WHERE condition, a second transaction inserts a row that satisfies that WHERE condition, and the first transaction re-reads for the same condition, retrieving the additional 'phantom' row in the second read
  • Interview Candidate
  • 7
  • 5561

Showing Answers 1 - 7 of 7 Answers

mcawal

  • Apr 6th, 2006
 

Option A,B,D isolation levels Does not prevent phanto read problem

Option C isolation level prevent the Phantom read problem

  Was this answer useful?  Yes

charankk

  • May 2nd, 2008
 

Guys ...do not give any wrong answers,If you know very well then answer.

Here to avoid the phatom read ,we will go for TRANSATION_SERIALIZABLE ,Which blocks the records in row level .But this affects performance drastically .
Hence the answer is  "C "

  Was this answer useful?  Yes

sanky

  • Jun 3rd, 2014
 

Charankk, please read question carefully. We need ans for which allows phantom read. We dont need ans for which does not allows. Ans is A,B,D

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions