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

What is the function of compareto in java?

600


Is main a function?

522


What are the object and class classes used for?

574


Can we use catch statement for checked exceptions?

529


What are internal and external variables?

550






What is the difference between a synchronized method and a synchronized block?

620


What is meant by object?

583


What are inbuilt functions in java?

569


What is the difference between applet and application?

555


What are class members by default?

667


What is namespace in java?

550


What are the advantages and disadvantages of reference counting in garbage collection?

585


What is the driver class?

576


What is meant by collection in java?

566


Is java hashset ordered?

591