| Other DB2 Interview Questions |
|| Asked @
|What will the FREE command do to a plan?
|What is a data page?
|How would one remove old reorg information from the DB2
|what is the maximum number of tables that can be joined ?
|What are common abends
|In db2, how do you insert multiple rows in 1 query using a.)
Cursors, b.) Normal query?? Give syntax for both.
|Which DB2 catalog tables are used to produce a list of
table column by table for all tables in a database?
|explain about index with examples
|what is the Foreign key? explain?
|What is DCLGEN ?
|Suppose we are doing transaction in a table and abend happened in
between. Suppose i have completed the transaction upto X rows and
I want to start the transaction again where the abend happened. I
don't want to do the transaction from the first record. Then what
i have to do.
|How can you display the current date & current time ?
|For more DB2 Interview Questions Click Here |