DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What is the maximum size of a char data type in db2?

739

What is cursor stability in db2?

1014

What are the various data types available in db2?

783

Which component is used to execute the sql statements?

797

What are the rules for db2 programming?

800

Define db2 and its databases?

770

How can you quickly find out the # of rows updated after an update statement?

766

Can there be more than one cursor open for any program?

865

What are the 2 sqlcodes that are returned?

797

Where do you specify them?

844

When the like statement is used?

808

How to retrieve rows from a db2 table in embedded sql?

930

Are views updateable?

812

What is reorg?

778

How can you find out the # of rows updated after an update statement?

821

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is db2 catalog database?

749

What is explain in db2?

728

Why do we use cursor?

755

What is load replace in db2?

711

What is database manager in db2?

718

What is the syntax for FETCH in DB2 ?

847

What is a dbrm in db2?

721

What are iseries servers?

723

What is a system catalog table in db2?

771

What is page size in db2?

704

How to find the number of rows in db2 tables?

768

What is database reorganization?

778

How would you find out the total number of rows in a db2 table?

750

Explain the contents that are a part of dclgen.

817

Is it possible using max on a char column?

781

For More Un-Answered { DB2 } Questions Click Here