What is the difference between CS and RR isolation levels?
Answer / s
CS - page or row locks are released as soon as the cursor
is moved to another row or page.
RR - page or row locks are held for all accessed rows,
qualifying or not atleast until the next commit point.
| Is This Answer Correct ? | 8 Yes | 2 No |
What is difference between *omit and *nopass?
how to check the table is empty or not?
How can you find out the # of rows updated after an update statement?
Is schema the same as database?
what is a plan and how do you refer the plan in the program?
Explain about rct.
WHAT IS MEANT BY COMMIT COMMAND?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
I have some 3 particular fields ..i want to know which all tables have those 3 fields. Is there any way to identify.. can we know by quering system tables..
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
How will you return the number of records in table?
What is db2 optimizer?