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 16626

What is buffrpool? Where we use it ?

Tesco,

2 14005

what is Runstats? Whem will u choose to runatats?

Danske,

1 13184

what is REORG? what is the use?

4 15704

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 51316

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 7611

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

1 9277

What is a clustered index?

1 12450

When will you chose to run RUNSTATS?

1 9398

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

IBM,

3 9690

What is meant by a unit of recovery?

1 6514

What is CHECK PENDING ?

5 19934

What is a thread?

3 8140

What is filter factor?

2 10668

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

IBM,

1 9302

Post New DB2 Questions

Un-Answered Questions { DB2 }

What language is db2 written in?

1049

How to find the number of rows in a db2 table?

1120

What is cursor stability in db2?

1363

What is database alias db2?

1132

What are the various data types available in db2?

1094

How do I add a column to a table in db2?

1104

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1109

What is deadlock in db2?

1073

How can we retrieve the total number of records in RPG & CLLE?

656

What is ibm db2 database?

1014

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

What is collection in db2 bind?

1019

What is the difference between cursor and select statement?

1112

What is the role of union all and union

1129

What is the picture clause of null indicator variable?

1138

For More Un-Answered { DB2 } Questions Click Here