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 20397

How does DB2 store NULL physically?

2 10937

Explain the use of the WHERE clause?

1 4098

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

CSI, CTS,

1 9535

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

1 4413

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

3 8427

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

2 9088

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

1 4747

What is an asychronous write?

1 4637

What is correlated subquery?

1 5010

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

1 4041

What is a precompiler?

2 5956

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

2 5622

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

2 6188

What will the COMMIT accomplish?

5 7837

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is concurrency?

1232

What is catalog database in db2?

1162

Define buffer pool.

1053

Explain package in db2 and its advantages?

1215

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1436

What is the cobol picture clause of the db2 data types date, time, timestamp?

1066

What is an instance database?

1052

How do I delete a column in db2?

1109

Explain correlated sub-queries.

1031

Mention the different locking levels that are available in db2.

1132

What does runstats do in db2?

1116

What is null value in db2?

1024

B37 abend during spufi?

1455

What is lock escalation in db2?

1031

What is a db2 package?

1053

For More Un-Answered { DB2 } Questions Click Here