Define check constraint.
define clustering index.
List out the three types of page locks that can be held.
Explain about rct.
Explain correlated sub-queries.
Mention the location where the output received from explain statement is stored.
What are the uses of db2 optimizer?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
Before you give the explain statement, what are the prerogatives?
What is the information associated with sysibm.syslinks table?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is the purpose of using commit?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is meant by explain?
Define db2.