DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

What are foreign keys in db2?

1103

Describe major components of db2?

1091

Explain about rct in db2?

1109

What is db2?

1182

Explain various types of locks in db2?

1150

What is the use of db2 optimizer?

1114

What are the full forms of spufi and dclgen and why are they used?

1087

Give a brief description of db2 isolation levels?

1072

What is db2 and what is the use of db2 optimizer?

1065

Mention data types used in db2 ?

1156

Explain the contention situations caused by locks?

1070

What is buffer pool and list some of them?

1028

Mention and explain the contention situations caused by locks?

1 1504

What is meant by union and union all?

1012

Explain package in db2 and its advantages?

1217

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

1066

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1105

Explain about open switch business continuity software?

1133

What is runstats db2?

1036

What is dclgen (declaration generator)?

1059

What does db2 mean?

1017

What is the difference between dbm cfg and db cfg file in db2 ?

1534

How do you find the maximum value in a column in db2?

1104

What is the use of predicate?

1041

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3154

What is a collection in db2?

1034

what is a corelated subquerry?

1122

When the like statement is used?

1222

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2097

How many types of page locks can be held in db2?

1040

For More Un-Answered { DB2 } Questions Click Here