DB2 Interview Questions
Questions Answers Views Company eMail

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

588

What is cursor stability in db2?

811

What are the various data types available in db2?

634

Which component is used to execute the sql statements?

621

What are the rules for db2 programming?

643

Define db2 and its databases?

620

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

632

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

660

What are the 2 sqlcodes that are returned?

643

Where do you specify them?

681

When the like statement is used?

640

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

730

Are views updateable?

645

What is reorg?

619

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

641


Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain what are the various isolation levels possible?

610


How to find the number of rows in db2 tables?

617


What are iseries servers?

566


Mention the location where the output received from explain statement is stored.

628


What is difference between isnull and coalesce?

620






What is explain in db2?

585


What is the usage of open cursor command?

599


What do you mean by rollback?

572


What is the connection string to connect to the DB2 Database ?

614


When the like statement is used?

640


What is the use of dclgen in db2?

588


How many types of page locks can be held in db2?

593


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

579


What is the difference between drop table and delete table?

554


can all users have the privilage to use the sql statement select * (dml)?

642