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 process of precompiler?

2 16722

What is buffrpool? Where we use it ?

Tesco,

2 14100

what is Runstats? Whem will u choose to runatats?

Danske,

1 13252

what is REORG? what is the use?

4 15845

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 51570

How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 7741

How do you filter out the rows retrieved from a Db2 table ?

1 9343

What is a clustered index?

1 12516

When will you chose to run RUNSTATS?

1 9462

What does DML stand for and what are some examples of it?

IBM,

3 9814

What is meant by a unit of recovery?

1 6598

What is CHECK PENDING ?

5 20101

What is a thread?

3 8253

What is filter factor?

2 10774

What's the maximum number of volumes that can be added to a STOGROUP?

IBM,

1 9389

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a db2 table?

1061

What is package in cobol db2?

1158

How to connect to db2 database from windows command line?

1128

What is null value in db2?

1074

Explain packages.

1163

Explain in detail about buffer manager and its functionalities?

1135

What is runstats and reorg in db2?

1354

What is difference between isnull and coalesce?

1104

What is a trigger in the db2 database?

1137

What are bind parameters in db2?

1093

What is a bind in db2?

1100

What are iseries servers?

1126

What is dclgen (declaration generator)?

1110

How do I import data from excel to db2?

1126

What is the information associated with sysibm.syslinks table?

1166

For More Un-Answered { DB2 } Questions Click Here