| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is a plan and how do you refer the plan in the
program? | Xansa | 1 |
| What is an inner join, and an outer join ? | CTA | 1 |
| What is CHECK PENDING ? | | 2 |
| what is REORG? what is the use? | | 3 |
| I have a DB2 table which has 1000 rows.after udatingg first
110 rows, my job abends. Now what I have to do if I want to
restart the job next time so that it should start updating
from 111th row (without updating first 110 rows again). | Wipro | 5 |
| Explain the EXPLAIN statement? | | 1 |
| What is cursor stability? | | 1 |
| What is a LIKE table and how is it created? | | 1 |
| What are some SQL aggregates and other built-in functions? | | 1 |
| I use CS and update a page. Will the lock be released after
I am done with that page? | | 2 |
| How we create a tables in DB2 ?Previously client has using
7 letters for user id,now he wants to increase the letters
from 7 to 12 for user id.How we can do it? | Wipro | 4 |
| Explain an outer join? | | 1 |
| In SPUFI suppose you want to select maximum of 1000 rows,
but the select returns only 200 rows. What are the 2
SQLCODEs that are returned? | | 1 |
| what is the name of the default db2 catalog database? | | 1 |
| Once you create a view, where would information about the
view be stored? | | 1 |
| How to insert more than one record using insert?
| IBM | 4 |
| When do you specify the isolation level? How? | | 1 |
| What is a host variable? | | 1 |
| When is the authorization check on DB2 objects done - at
BIND time or run time? | | 1 |
| Which catalog table stores referential constraints? | | 1 |
| |
| For more DB2 Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
