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 7075

What is the picture clause of the null indicator variable?

6 19242

What will the FREE command do to a plan?

2 5837

What is a DB2 bind?

Logica CMG,

1 7303

What information can you find in SYSIBM.SYSLINKS table?

TCS,

1 9294

What is the difference between IN subselects and EXISTS subselect?

HCL, PreVator, TCS,

1 11089

What is meant by concurrency?

1 6174

What is subquery ?

6 12647

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

1 5866

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

1 7458

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

IBM,

1 6310

What are the various locks available?

CTS,

5 12321

What will the DB2 optimizer do?

2 6331

What are the contents of a DCLGEN?

MetLife,

4 13291

What is deadlock?

2 7142

Post New DB2 Questions

Un-Answered Questions { DB2 }

Which component is used to execute the sql statements?

1096

What is dbrm?

1105

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1065

Explain the benefits you can get from mainframe connect?

970

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1060

How to fetch the last row from the table in SQL (db2)?

1653

Define buffer pool.

1054

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

1040

Comment whether the cursor is closed during commit or not.

1105

What is phantom read in db2?

1158

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2211

What is difference between alias and synonym in db2?

1141

What is meant by explain?

1133

Explain how can you do the explain of a dynamic sql statement?

1125

Explain package in db2 and its advantages?

1218

For More Un-Answered { DB2 } Questions Click Here