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 16725

What is buffrpool? Where we use it ?

Tesco,

2 14104

what is Runstats? Whem will u choose to runatats?

Danske,

1 13252

what is REORG? what is the use?

4 15846

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 51587

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 7742

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

1 9345

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 6601

What is CHECK PENDING ?

5 20106

What is a thread?

3 8258

What is filter factor?

2 10776

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

IBM,

1 9393

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is bind and rebind in db2?

1186

What is the usage of open cursor command?

1143

Is ibm db2 open source?

1127

What is coalesce in db2?

1182

Explain the function of data manager.

1095

What is the use of runstats in db2?

1178

How to get the ddl of a table in db2?

1168

What is commit in db2?

1104

What are db2 objects?

1089

What is data manager?

1101

How do I import a csv file into db2?

1039

What is bind in db2?

1096

How to execute stored procedures?

1175

How to find the number of rows in db2 tables?

1127

What is performance tuning db2?

1109

For More Un-Answered { DB2 } Questions Click Here