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 14783

What is buffrpool? Where we use it ?

Tesco,

2 12313

what is Runstats? Whem will u choose to runatats?

Danske,

1 11831

what is REORG? what is the use?

4 13228

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 47574

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 6249

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

1 8417

What is a clustered index?

1 11373

When will you chose to run RUNSTATS?

1 8445

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

IBM,

3 8051

What is meant by a unit of recovery?

1 5397

What is CHECK PENDING ?

5 17745

What is a thread?

3 6502

What is filter factor?

2 9507

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

IBM,

1 8182

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is concurrency?

711

What is a cursor in programming?

598

How do you stop a db2 database in linux?

570

What is blu acceleration in db2?

608

What are the various data types available in db2?

635

How do I connect my db2 database to ibm?

604

What is a system catalog table in db2?

590

What is buffer pool in the db2 database?

621

Define db2.

672

How do we specify index to include or not during bind process.

1674

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

203

What is a Foreign Key?

660

What is the cobol picture clause of the db2 data types date, time, timestamp?

621

What are db2 objects?

641

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

605

For More Un-Answered { DB2 } Questions Click Here