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 declare cursor?
Mention the location where the output received from explain statement is stored.
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
What are foreign keys?
what is plan? is plan executable or package?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
What are simple, segmented and partitioned table spaces ?
can you use symbolic parameters in JOB?
What is db2 stogroup?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How to find the number of rows in db2 tables?