| Other DB2 Interview Questions |
|| Asked @
|What is an inner join, and an outer join ?
|I have a table(product),It contain fields(productname,cost).
I want to retrieve the product name ,which cost is second
maximum in the table?
|can i code union in cobol-db2 pgm ?
|Explain transactions, commits and rollbacks in DB2.
|Which one allows duplicate values Union or Union All ?
|Can a unique index have more than one null value? If not,
what error code is given if an attempt is made to insert
more than one null value?
|What is a DB2 access path?
|EXPLAIN has output with MATCHCOLS = 0. What does it mean?
|when i am trying to update a table having 1000 rows. the
program abends.how we will come to know the last successful
updated row was. we are not using any commit operations
|What are the advantages of using a PACKAGE?
|what is a trigger and types of triggers
|What is the difference between a package and a plan?
|For more DB2 Interview Questions Click Here |