What are the levels of isolation available with DB2V4
Answers were Sorted based on User's Feedback
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 |
Answer / s
CS Cursor Stability
RS Read Stability
RR Repeatable Read
UR Uncomitted Read
Is This Answer Correct ? | 0 Yes | 1 No |
When do you specify the isolation level? How?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
When is the access path determined for dynamic SQL?
How to rename a table in DB2 ?
What is a bind in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
how we will do null data selection in cobol-db2 program
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Where is the access path logic created by the DB2 Optimizer stored?
How do you define a correlated name?
Is db2 a database?