DB2 Interview Questions
Questions Answers Views Company eMail

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

690

What is cursor stability in db2?

961

What are the various data types available in db2?

745

Which component is used to execute the sql statements?

762

What are the rules for db2 programming?

764

Define db2 and its databases?

731

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

733

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

819

What are the 2 sqlcodes that are returned?

759

Where do you specify them?

805

When the like statement is used?

764

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

885

Are views updateable?

775

What is reorg?

736

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

769


Post New DB2 Questions

Un-Answered Questions { DB2 }

Give the name of some fields form sqlca.

738


What are the various data types available in db2?

745


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

8041


What is runstats and reorg in db2?

959


What is a db2 cursor?

752






Which component is responsible for db2 startup and shutdown?

742


Which isolation level provides maximum concurrency?

809


What is copy pending and check pending in db2?

682


What are the contents of dclgen?

779


Mention some fields that are a part of sqlca.

706


What does db2 plan contain?

685


What is difference between isnull and coalesce?

725


What is the maximum No of rows per page?

742


How to resolve deadlock issue

18698


What is db2 stogroup?

817