| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a DBRM, PLAN ? | | 1 |
| What is SPUFI? | | 1 |
| I have a table which has thousand of records i want to
fetch only record num 100 to record num 200. Write a query
that satisfies this criteria.(Cant use any keys)
Anyone please reply ASAP! | Tech-Mahindra | 10 |
| Can we use select * statement in cobol program without
giving field names ??? | Zensar | 2 |
| What is the difference between static and dynamic SQL? | | 1 |
| How will you delete duplicate records from a table? | | 2 |
| What are leaf pages? | | 1 |
| What is a synonym? How is it used? | | 2 |
| what's the equivalent Cobol Data type for Decimal(x,y) in
DB2? what does the current SQLID register contain? | Cap-Gemini | 2 |
| How would one remove old reorg information from the DB2
catalog? | | 1 |
| What is tablespace? | | 2 |
| Describe what a storage group(STOGROUP) is? | | 1 |
| What does the RUNSTATS Utility do? | | 2 |
| When is the authorization check on DB2 objects done - at
BIND time or run time? | | 1 |
| What is an intent lock? | | 1 |
| What is filter factor? | | 2 |
| What is the difference between TYPE 1 index & TYPE 2 index | | 1 |
| What is sqlcode -922 ? | | 1 |
| What is a cursor and what is its function? | | 2 |
| What is a recovery log? | | 1 |
| |
| For more DB2 Interview Questions Click Here |
Site Map
