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 20513

How does DB2 store NULL physically?

2 11014

Explain the use of the WHERE clause?

1 4178

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

CSI, CTS,

1 9621

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

1 4490

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

3 8531

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

2 9176

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

1 4812

What is an asychronous write?

1 4710

What is correlated subquery?

1 5084

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

1 4122

What is a precompiler?

2 6063

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

2 5744

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

2 6292

What will the COMMIT accomplish?

5 8001

Post New DB2 Questions

Un-Answered Questions { DB2 }

What do you mean by rollback?

1027

What is dclgen in db2?

1194

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

1154

What is concurrency?

1297

What is the difference between db2 and oracle?

1175

How connect db2 database to datastage?

1289

What is a db2 cursor?

1106

How to find primary key of a table in db2?

1111

What is the max length of sqlca?

1266

Explain about mirror activator disk mirroring?

1059

What is commit in db2?

1101

What is the use of db2?

1111

What is universal database?

1117

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1232

What is dbrm in db2 database?

1187

For More Un-Answered { DB2 } Questions Click Here