IBM DB2 Interview Questions

 
1.
what are the bind parameters IBM DB2?
2.
Is it Possible to declare or create a cursor for UPDATE of
table? If yes tell me how? If no Tell me why?
3.
Cursors can be declared in both working-storage & procedure
division, Agreed.
But is there any difference? If could you please suggest
what is the difference.
TIA
4.
If I have 5 Queries in a DB2 Cobol program , while
precompiling how many DBRMs will get created and How many
Plans and Packages will get created while Bind Process?
5.
could you give me an example how, where i code CHECKPOINT
and restart. I need and example
6.
Can you search give an array in the WHERE clause of a db2
query?
7.
Can i insert bulk records into a db2 table using qmf of
spufi only.
8.
I have some 3 particular fields ..i want to know which all
tables have those 3 fields. Is there any way to identify..
can we know by quering system tables.
9.
when we are tying to update a table having 100 rows. if the
program abends when updating 51 row . how to start updating
again from the 51 row . What was the logic?
10.
what is the difference between normal select query and
currosor
11.
What are Bind concepts in DB2 cobol?
12.
When DB2 connection fails, will online program work or give
errors?
13.
EXPLAIN has output with MATCHCOLS = 0. What does it mean? ?
14.
What is DCLGEN ?
15.
Can GROUP BY and ORDERED BY used in a single query?
16.
Can you have more than one cursor open at any one time in a program ?
17.
What is a composite index and how does it differ from a multiple index?
18.
What are the disadvantages of PAGE level lock?
19.
How does DB2 determine what lock-size to use?
20.
What are delete-connected tables?
21.
What is a precompiler?
22.
What is the diff bet plan,package,dbrm?
23.
Give the COBOL definition of a VARCHAR field.
24.
When can an insert of a new primary key value threaten referential integrity?
25.
What are foreign keys in DB2?
26.
Is DECLARE CURSOR executable?
27.
What is the self-referencing constraint?
28.
A user
defined name that is the anchor for packages. It has not physical existence. Main usage is to group packages.

In SPUFI suppose you want to select max. of 1000 rows , but the select returns only 200 rows.
29.
What is a clustering index ?
30.
What is the difference between primary key & unique index ?
31.
What is sqlcode -922 ?
32.
What is sqlcode -811?