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 16409

What is buffrpool? Where we use it ?

Tesco,

2 13845

what is Runstats? Whem will u choose to runatats?

Danske,

1 13051

what is REORG? what is the use?

4 15461

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 50937

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 7411

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

1 9145

What is a clustered index?

1 12345

When will you chose to run RUNSTATS?

1 9281

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

IBM,

3 9503

What is meant by a unit of recovery?

1 6369

What is CHECK PENDING ?

5 19651

What is a thread?

3 7936

What is filter factor?

2 10511

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

IBM,

1 9178

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is package in cobol db2?

1075

How to rename a table in DB2 ?

1029

What is meant by explain?

1061

Is db2 a database?

910

What are union and union all?

920

How can you do the explain of a dynamic sql statement?

1012

What is universal database?

1029

What is host variable in db2 cobol?

1027

How to find the maximum value in a column in the db2 database?

1015

What is a bind card?

1141

What is check constraint in db2?

1011

What is bufferpool in db2?

984

Which is faster delete or truncate?

1068

What is the meaning concurrency in the db2 database?

1055

Why db2 is called db2?

969

For More Un-Answered { DB2 } Questions Click Here