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 |
which of the following can be used as a check protection symbol a.Z b.S c.* d.+
What is comp-1 and comp-2?
How to resolve the soc4 and soc7 errors?
Differentiate cobol and cobol-ii. (Most of our programs are written in cobolii, so, it is good to know, how, this is different from cobol)?
what is SYNCHRONIZATION?
How to change size of Initial number of records to *NOMAX for ALL PF files from perticular library, how can I do that
Is It Possible to Update or change in VIEW Mode?
What will happen if you code GO BACK instead of STOP RUN in a stand alone COBOL program ?
8 Answers Arigo Infotech, IBM,
How do you define a sort file in JCL that runs the COBOL program?
How do you come out of an EVALUATE statement?
What is report-item?
With in these three which one is the default one Call Reference, Call By Value, Call By Content.-Which one is default?