What are the levels of isolation available with DB2V4

Question Posted / guest

2 Answers
4734 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the levels of isolation available with DB2V4..

Answer / nag(igate)

CS Cursor Stability
RS Read Stability
RR Repeatable Read
UR Uncomitted Read
NC no commit-similar to UR

Is This Answer Correct ?

0 Yes

0 No

What are the levels of isolation available with DB2V4..

Answer / s

CS Cursor Stability
RS Read Stability
RR Repeatable Read
UR Uncomitted Read

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More DB2 Interview Questions

What is the maximum No of rows per page?

0 Answers IBM,

How to fetch the last row from the table in SQL (db2)?

0 Answers

how to resolve -805. give clear explination for that

2 Answers IBM,

What is the difference between IN subselects and EXISTS subselect?

1 Answers HCL, PreVator, TCS,

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

0 Answers

What is the syntax of SELECT statement when embedded in a COBOL program?

2 Answers

what is difference between Static call and Dynamic call? How does it function?

1 Answers Syntel,

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers

what types of copies can be made with the COPY Utility ?

1 Answers

why we go for SPUFI for creating tables or for sql queries?

4 Answers

How does coalesce work?

0 Answers

What is the SQL query to select, delete and get count of duplicate rows in DB2?

2 Answers

For more DB2 Interview Questions Click Here