What are the Isolation levels possible ?
Answers were Sorted based on User's Feedback
Answer / rafee s
CS -- Cursor Stability.
RR -- Repeatable Read.
UR -- Uncommitted Read
RS -- Read Stability
NC -- No Commit (smiler to UR)
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / narayana reddy
CS-cursor stability
RR-repeatable read
UR-uncommited read
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / krishnan
CS-cursor stability
RR-repeatable read
UR-uncommited read
CR-Cursor Readabiliy
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / viratarya
CS -- Cursor Stability.
RR -- Repeatable Read.
UR -- Uncommitted Read
RS -- Read Stability
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveen87ginjupalli
CS-CURSOR STABILITY
RR-REPEATABLE READ
| Is This Answer Correct ? | 0 Yes | 4 No |
can any one give the list of some important sql abend codes which r frequently asked in interviews?
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
Why use RUNSTAT Utility?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
How to access db2 tables in mainframe?
How to create a table using embedded sql?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What is multi row fetch in db2?
What is a precompiler?
Differentiate between cs and rr isolation levels? Where do you specify them?
What is cursor in dbms?