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 was java originally called?

514


What is method with example?

583


What is the += operator called?

579


What is nested top-level class?

580


Do I need to import java.lang package any time? Why?

742






Write a program to check string is palindrome without using loop?

570


How many types of gc are there in java?

570


What is variable and its types?

547


What is the difference between an argument and a parameter?

544


What is a method in programming?

641


How do you sort arrays in java?

528


What makes a function well defined?

525


Explain the difference between jdk, jre, and jvm?

595


What are namespaces in java?

527


Program to Find the second largest element in an array.

591