What are the three types of page locks that can be held?
Answer Posted / s
I think you mean the three types of LOCK MODES.
S Share
U Update
E Exclusive
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
define clustering index.
What is dclgen in db2?
What is the difference between cursor and select statement?
Define check constraint.
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Which isolation level provides maximum concurrency?
Which component is used to execute the sql statements?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is db2?
What is isolation level in db2?
What is rct?
How would you find out the total number of rows in a db2 table?
Is the primary key a clustered index?
What is null indicator in db2?