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 16467

What is buffrpool? Where we use it ?

Tesco,

2 13892

what is Runstats? Whem will u choose to runatats?

Danske,

1 13088

what is REORG? what is the use?

4 15512

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 51015

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 7448

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

1 9173

What is a clustered index?

1 12365

When will you chose to run RUNSTATS?

1 9308

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

IBM,

3 9543

What is meant by a unit of recovery?

1 6397

What is CHECK PENDING ?

5 19715

What is a thread?

3 7980

What is filter factor?

2 10536

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

IBM,

1 9202

Post New DB2 Questions

Un-Answered Questions { DB2 }

Mention some fields that are a part of sqlca.

989

How do I delete a table in database?

992

What is the syntax for creating a table in the db2 database?

1073

What is the use of db2?

1014

What does db2 mean?

965

How many databases can be created inside an instance in db2 ?

994

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

1062

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1003

When the like statement is used?

1172

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2188

How do you eliminate duplicate values in db2?

1122

What is a system catalog table in db2?

1123

What is cloudant database?

1050

What does a deadlock mean in DB2?

1115

What is the difference between nvl and coalesce?

1022

For More Un-Answered { DB2 } Questions Click Here