When do you specify the isolation level? How?
Answer / s
Isolation level can be specified at BIND time using the
ISOLATION parameter or in the SQL statement using the WITH
clause
WITH UR;
| Is This Answer Correct ? | 5 Yes | 0 No |
What is data manager?
How to update more then one record using update?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is a recovery log?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is a DB2 bind?
What is meant by the attachment facility?
define clustering index.
What is Reorg Recovery? when will you run it?
Mention and explain the contention situations caused by locks?
what is a corelated subquerry?
Can you tell me how can you find out the # of rows updated after an update statement?