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 COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?

3 20399

How does DB2 store NULL physically?

2 10938

Explain the use of the WHERE clause?

1 4102

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

CSI, CTS,

1 9538

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

1 4418

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

3 8429

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

2 9092

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

1 4747

What is an asychronous write?

1 4641

What is correlated subquery?

1 5011

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

1 4041

What is a precompiler?

2 5960

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

2 5624

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

2 6188

What will the COMMIT accomplish?

5 7845

Post New DB2 Questions

Un-Answered Questions { DB2 }

When reorg is used?

1129

What is the difference between plan and package in db2?

1113

What is the difference between bind and rebind in db2?

1453

What are the rules for db2 programming?

1089

How to check table size in db2 sap?

1040

What is package in db2 mainframe?

988

What are the prerogatives?

1080

How do I add a column in db2?

1048

Define db2.

1116

What is dbrm? When it will be created?

1029

Define sqlca.

1113

What is the difference between db2 and oracle?

1133

How to take backup of table in db2?

1075

How does coalesce work?

1023

What is the maximum size of varchar data type in db2?

1135

For More Un-Answered { DB2 } Questions Click Here