What is isolation level in db2?
Why do we use cursor?
What are the four lockable units for DB2?
can we view the access paths created by dbrm ? how ? thx
Before you give the explain statement, what are the prerogatives?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is declare cursor?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
What is a collection in db2?
What is the result of open cursor statement?
What is ALTER ?
What is a synonym ?