| Other DB2 Interview Questions |
|| Asked @
|Is it Possible to declare or create a cursor for UPDATE of
table? If yes tell me how? If no Tell me why?
|How many Buffer pools are there in DB2 and what are they?
|What happens to the PLAN if index used by it is dropped?
|How do run the JCL which has 25 steps by skipping the
following steps 5, 10,15 and 25 without using COND statement
|What is the function of the Data Manager?
|wht happens if we close cursor with cursor with hold option?
|What do you do to keep the cursor from closing after a
|I have two tables A and B. Both tables are connected with SSN
number as foreign key. I want to retrieve a column data from B
table. How will you write a query?
|1. what if null values retrived from database and no null
indicator mentioned in query. What is sql code.
|What can the SET option of the Repair Utility accomplish?
|What is a DB2 bind?
|What is the purpose of the QUIESE Utility?
|For more DB2 Interview Questions Click Here |