| Other DB2 Interview Questions |
|| Asked @
|What do you need to do before you do EXPLAIN?
|is it possible to get -811 error when you use cursors. why?
|What is the purpose of the WHENEVER statement?
|How do run the JCL which has 25 steps by skipping the
following steps 5, 10,15 and 25 without using COND statement
|How does DB2 determine what lock-size to use?
|While creating a table, by mistake you have given size of one
field as 10. But as per requirement size should be 8. What is
your next step?
|5 rows are inserted to a DB2 Table. Next 3 of those are
updated, then a rollback is issued. What would happen when
the rollback is issued?
|how to get duplicate records from tables?write qurey for this?
|If a non-DB2 program calls a DB2 program, the calling
program's name will be there in SYSIN of IKJEFT01 and the
plan name will be that of the called program. But is a bind
needed or a plan has to be created for the non-DB2 program
|What is meant by a unit of recovery?
|What is a LIKE table and how is it created?
|OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2
OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE
SAME THEN WHAT IS THE USE OF OUTER JOINS.
|For more DB2 Interview Questions Click Here |