What are ISOLATION LEVELS? Where do we need to specify them?
Answers were Sorted based on User's Feedback
Answer / shreya
An isolation level determines how data is locked or
isolated from other processes while that data is being
accessed.these can be specified in 4 ways-
1)RR(Repeatable read)
2)RS(Read stability)
3)UR(uncommited read)
4)cs(cursor stability)
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / harish
isolation levels r specified when we do bind, they avvoid
concurrency and mauntain integrity of data....isolation
levels r cursor stabily, repatable read.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ashu
An isolation level determines how data is locked or
isolated from other processes while that data is being
accessed.It is page level locking.these can be specified in
4 ways-
1)cs(cursor stability):-
Used when concurrency is important.
2)RR(Repeatable read)
Used when Data Integrity is Important.
3)RS(Read stability)
4)UR(uncommited read)
Uncommited read or Dirty Read.
Is This Answer Correct ? | 1 Yes | 0 No |
Explain call by context by comparing it to other calls.
If by mistake we MOVE a working storage variable into LINKAGE area. What will happen??
what is the advantage of using redefines instead of delaring the variables ?
What is SQL Code -904 and -903 in DB2 And how to handle it?
What is the Purpose of POINTER Phrase in STRING command
if we have " ibm mainframe ",in that how to remove first and last leading space eg:"ibm mainframe" like that the answer we need
what is soc7 abend?how u can trace it?
given the following: 77 A PIC 9V9 VALUE 9.5 77 B PIC 9 VALUE 9. 77 C PIC V9 VALUE 0.8 77 D PIC 9 77 E PIC 9 77 F PIC 9V999 what are the contenta of D E nad F after the following statements are executed: COMPUTE F ROUNDED=A+C/B MULTIPLY A BY C GIVING E ADD B C A GIVING D ROUNDED a.F=9.589 E=8 D=1 b.F=9.589 E=8 D=9 c.F=9.589 E=7 D=9 d.F=9.589 E=7 D=1
what is the difference between implicit and explicit scope terminator with example?
What are declaratives and what are their uses in cobol?
How do you reference the fixed block file formats from cobol programs
is it possible to rename 01 level?