What do you mean by dirty read ?

Answer Posted / ram g

dirty read is an isolation level. it wont give exclusive
lock on table. what it says is that..when the user1 start
reading db and inserting a row1 while user2 reads row1 now
user1 rollback data now user2 read data which is not really
exist.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is control area?

644


What is the purpose of control intervals in vsam?

523


we can define the ksds cluster by two ways by using the file-aid or by using the idcams utility. Explain them.

728


what is the syntax of ams modal commands?

774


What is a ci split?

554






difference between vsam and database tables

641


why ci and ca splits are not possible in esds and rrds?

709


What is a ci split? What is a ca split?

653


write a program to read from a VSAM file , there will be a 5 records to create name. empno. resignation and address to update in a db2 table and call another program using dynamic call to find the matching fields in program 1 to update in db2 table. anybody pls send de program for dis ? thanks in advance...

2279


Can you delete vsam files with the delete option of the disposition parameter of jcl?

656


explain how many ways you can load data in a vsam cluster?

582


how can you copy to a vsam cluster?

627


If fspc(100 100) is specified does it mean that both the control interval and control area will be left empty because 100 % of both ci and ca are specified to be empty?

637


what parameter in the define aix option is used to determine the maximum number of duplicate keys allowable ?

568


what are the additional information you should give in the dd statement while defining the next generation of a gdg?

580