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

DB2 Interview Questions

Questions Answers Views Company eMail

What are the 4 environments which can access DB2 ?

2 6937

What is the picture clause of the null indicator variable?

6 18991

What will the FREE command do to a plan?

2 5688

What is a DB2 bind?

Logica CMG,

1 7184

What information can you find in SYSIBM.SYSLINKS table?

TCS,

1 9182

What is the difference between IN subselects and EXISTS subselect?

HCL, PreVator, TCS,

1 10965

What is meant by concurrency?

1 6075

What is subquery ?

6 12394

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 5766

How does the processing of a correlated subquery differ from a non correlated subquery?

1 7329

Can you define an Index if the table size less than 10 PAGES?

IBM,

1 6213

What are the various locks available?

CTS,

5 12126

What will the DB2 optimizer do?

2 6206

What are the contents of a DCLGEN?

MetLife,

4 13070

What is deadlock?

2 6964

Post New DB2 Questions

Un-Answered Questions { DB2 }

What does db2 blu stand for?

1102

What is multi row fetch in db2?

988

Mention the definition of cobol in varchar field.

1180

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?

2024

Why cursor is used in db2?

986

What is runstats db2?

967

What is cascading rollback?

1135

On which levels locks can be applied?

1062

What is a buffer in memory?

1008

What are union and union all?

920

What is a db2 package?

991

Which isolation level provides highest data integrity?

1043

what is the role of the cursor in db2?

1002

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2868

What does runstats do in db2?

1025

For More Un-Answered { DB2 } Questions Click Here