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 20284

How does DB2 store NULL physically?

2 10854

Explain the use of the WHERE clause?

1 4020

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

CSI, CTS,

1 9433

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

1 4336

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

3 8319

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

2 8985

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

1 4679

What is an asychronous write?

1 4586

What is correlated subquery?

1 4917

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

1 3975

What is a precompiler?

2 5839

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

2 5539

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

2 6103

What will the COMMIT accomplish?

5 7677

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is dbrm in db2 database?

1053

Is ibm db2 free?

964

Where do you specify them?

1196

List out the data types available.

1104

How to execute stored procedures?

1078

What is meant by dclgen?

1071

What is the use of with ur in db2?

1014

Give a brief description of db2 isolation levels?

1025

What is the role of union all and union

1092

What is a db2 package?

1009

What is db2 and what is the use of db2 optimizer?

1006

What is dbrm? When it will be created?

981

How to restart a DB2 program?

1842

what is the sqlcode -501

12967

What is sqlca?

1015

For More Un-Answered { DB2 } Questions Click Here