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 16617

What is buffrpool? Where we use it ?

Tesco,

2 13988

what is Runstats? Whem will u choose to runatats?

Danske,

1 13174

what is REORG? what is the use?

4 15677

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 51279

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 7587

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

1 9261

What is a clustered index?

1 12440

When will you chose to run RUNSTATS?

1 9384

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

IBM,

3 9666

What is meant by a unit of recovery?

1 6495

What is CHECK PENDING ?

5 19905

What is a thread?

3 8108

What is filter factor?

2 10641

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

IBM,

1 9289

Post New DB2 Questions

Un-Answered Questions { DB2 }

Can we delete records from view?

963

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1077

What os does db2 run on?

976

What is the use of predicate?

1039

When do you specify the isolation level?

1027

Give a brief description of db2 isolation levels?

1066

what is the role of the cursor in db2?

1061

What is the purpose of rollback and commit?

1189

Is schema the same as database?

1053

Mention the various locks that are available in db2.

1035

What is the usage of open cursor command?

1100

What is the difference between bind and rebind in db2?

1447

What is db2 purescale?

993

what is the responsibility of the construction superintendent

2140

Why do we bind in db2?

1207

For More Un-Answered { DB2 } Questions Click Here