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 16623

What is buffrpool? Where we use it ?

Tesco,

2 13998

what is Runstats? Whem will u choose to runatats?

Danske,

1 13182

what is REORG? what is the use?

4 15686

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 51302

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 7600

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

1 9269

What is a clustered index?

1 12448

When will you chose to run RUNSTATS?

1 9390

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

IBM,

3 9678

What is meant by a unit of recovery?

1 6505

What is CHECK PENDING ?

5 19920

What is a thread?

3 8127

What is filter factor?

2 10654

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

IBM,

1 9298

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a bind card?

1216

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1270

Are view updateable?

1043

Where can you declare a cursor in a cobol-db2 program?

1077

Explain correlated sub-queries.

1032

Mention data types used in db2 ?

1157

What is the use of reorg in db2?

1084

How to find primary key of a table in db2?

1065

What is a system catalog table in db2?

1186

What is commit in db2?

1055

What is dbrm?

1105

what is a corelated subquerry?

1122

Name the lockable units in DB2?

1128

What db2 400?

1189

What is drop table?

1010

For More Un-Answered { DB2 } Questions Click Here