Answered Questions
Which of the following allows phantom read in JDBC, connection class?
Asked By: Interview Candidate
| Asked On: Dec 10th, 2005
A) transaction_read_uncommittedb) transaction_read_ committedc) transaction_serializabled) 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...
User Panel
Categories
Interview Coaching
Interview Question
Career Counselling
Copyright © 2013 GeekInterview.com | All Rights Reserved
NH
NH
These will allow phanthom read
Read_uncommited
Read_commited
Repeatable_read
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 "