wht is mean by dirty read?

Answer Posted / g.arun

Dirty read - Changes made during a Transaction is 'visible'
to other parties

Non Repeatable Read -

if Transcation T1 reads a row and Transcation T2 changes
the same row,when T1 rereads and sees the changes made by
T2.Then this is Non - Repeatable Read

Phantom Read - If Transcation T1 retrieves a bunch of
rows.Transcation T2 inserts a row,T1 rereads the query and
if T1 see the additional row,it is a ghost row to T1 then
this is called as Phantom Read

Is This Answer Correct ?    10 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about the interpreter in java?

621


Java openings 3 - 5 years, Lnt Infotech. requirements - core java, J2ee, struts, hibernate Interview Date:- 19 March 2011 Time:- 9:00 AM to 12:00 Pm Interview Location - L & T Infotech, Manapakkam, Chennai Refererral PS NO:- 291649 (Please mention this when u fill the form only then u will be considered for interview) Documents Required:- Latest Resume, Photograph and last 3 payslips Mail me on vasan2211@gmail.com once u appear for interview

2852


Can a constructor be private and how are this() and super() method used with constructor?

518


What are the drawbacks of singleton class?

527


What is cr keyboard?

650






What is 16 bits called?

493


Explain what do you mean by functional overloading in java?

553


What’s the difference between unit, integration and functional testing?

612


What do you mean by ordered and sorted in collections in java?

544


What is import java util arraylist?

650


how to know the total memory occupied by the objects in the ArrayList(Array list may contain duplicate objects)

1899


What is primitive data type in java?

537


Is array size fixed in java?

532


Name few "optional" classes introduced with java 8 ?

639


What are accessor methods in java?

546