DB2 Interview Questions
Questions Answers Views Company eMail

Define sqlca.

630

Explain packages.

635

Mention the definition of cobol in varchar field.

665

Explain the function done by data manager?

835

Define buffer pool.

604

Outputs of explain are with matchcols = 0. What does this signify?

597

Explain in detail about buffer manager and its functionalities?

534

Mention the various locks that are available in db2.

592

Explain about dbrm.

585

What does a deadlock mean in DB2?

630

What is the advantage in De-normalizing tables in DB2?

721

What parameters are used to control the free space in DB2?

621

How can record locking be achieved in those DB2 versions which do not support it?

591

Name the lockable units in DB2?

641

What is check constraint. Explain with example.

623


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is temporal table in db2?

565


What is dclgen (declaration generator)?

581


What are host variables in db2?

601


How is the value function used?

576


What is cascading rollback?

597






How to view db2 table structure?

567


Which command is used to remove all rows from a table?

534


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10633


What is scrollable cursor in db2?

564


What is a db2 tablespace?

572


Name the lockable units in DB2?

641


What is a db2 schema?

740


What is runstats utility in db2?

544


What do you mean by commit and rollback?

569


Explain about mirror activator disk mirroring?

533