DB2 Interview Questions
Questions Answers Views Company eMail

What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 18894

How does DB2 store NULL physically?

2 9921

Explain the use of the WHERE clause?

1 3191

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

CSI, CTS,

1 8527

How could one combine a set of incremental image copies into a single copy?

1 3479

When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?

3 7122

Is it mandatory to use DCLGEN? If not, why would you use it at all?

2 8011

What is a composite index and how does it differ from a multiple index?

1 3795

What is an asychronous write?

1 3865

What is correlated subquery?

1 4088

Can DASD types assigned to storage groups be intermixed (i.e., 3350s and 3380s)?

1 3309

What is a precompiler?

2 4566

Where would you find information about the type of database authority held by the user?

2 4707

How do you do the EXPLAIN of a dynamic SQL statement?

2 5076

What will the COMMIT accomplish?

5 6231


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is bind in db2?

583


How do I add a column to an existing table in db2?

565


What is load utility in db2?

638


What is null in db2?

555


Name the lockable units in DB2?

641






List out the data types available.

677


Who uses db2?

551


What is the use of value function?

603


What is a collection in db2?

563


What is cursor in dbms?

558


What is meant by explain?

636


Which component is responsible for db2 startup and shutdown?

604


Mention the definition of cobol in varchar field.

665


What is db2? Explain.

586


My sql statement select avg(salary) from emp yields inaccurate results. Why?

615