DB2 Interview Questions and Answers - DB2 Interview FAQs & DB2 Books

Interview Questions

Our Services

Get 9,000 Interview Questions & Answers in an eBook.

9500+ Pages
9000 Question & Answers
All Tech. Categories

14 MB Content

Get it now !!

Advertisements DB2 Interview Questions

COOLINTERVIEW.COM MAINFRAME INTERVIEW QUESTIONS DB2 INTERVIEW QUESTIONS QUESTIONS LISTING

DB2 Interview Questions & Answers

Below we have listed all the DB2 Interview Questions and answers. Feel free to comment on any DB2 Interview Questions or answer by the comment feature available on the page.

To buy an eBook containing 9000 Interview Questions, with Answers, click here.

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Next
Sort By : Latest First | Oldest First | By Rating

Question Rating View Answer

What is DCLGEN ? View Answer

What is the diff bet plan,package,dbrm? View Answer

EXPLAIN has output with MATCHCOLS = 0. What does it mean? ? View Answer

When do you use the IMAGECOPY? View Answer

What are the disadvantages of PAGE level lock? View Answer

What are PACKAGES ? ? View Answer

What is a collection? View Answer

What is the picture clause of the null indicator variable? ? View Answer

What is a clustering index ? View Answer

Is it mandatory to use DCLGEN? If not, why would you use it at all? View Answer

Can you have more than one cursor open at any one time in a program ? ? View Answer

How do you leave the cursor open after issuing a COMMIT? ( for DB2 2.3 or above only ) View Answer

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened? View Answer

What is REORG? When is it used? View Answer

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone? View Answer

Can GROUP BY and ORDERED BY used in a single query? View Answer

What is sqlcode -922 ? View Answer

What are the three lock types? View Answer

What is the difference between CS and RR isolation levels? View Answer

How does DB2 determine what lock-size to use? View Answer

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Next
A D V E R T I S E M E N T