DB2 Interview Questions
Questions Answers Views Company eMail

what is the process of precompiler?

2 14430

What is buffrpool? Where we use it ?

Tesco,

2 12005

what is Runstats? Whem will u choose to runatats?

Danske,

1 11510

what is REORG? what is the use?

4 12831

What is the difference between a package and a plan?

Infosys, L&T, Mphasis,

6 46593

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 6031

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

1 8155

What is a clustered index?

1 11131

When will you chose to run RUNSTATS?

1 8185

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

IBM,

3 7794

What is meant by a unit of recovery?

1 5178

What is CHECK PENDING ?

5 17331

What is a thread?

3 6209

What is filter factor?

2 9270

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

IBM,

1 7980


Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain the function done by data manager?

784


What is buffer pool and list some of them?

551


What are the prerogatives?

545


What are the uses of db2 optimizer?

731


What is the clustering index in the db2 database?

517






Explain about rct in db2?

563


What is the use of db2?

507


What kind of database is db2?

495


What is cascading rollback?

544


How can you classify the locks in db2?

566


How to create backup table in db2?

580


what is the sqlcode -501

10950


What is load replace in db2?

497


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

536


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

642