| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a DB2 plan? | | 4 |
| When can an insert of a new primary key value threaten
referential integrity? | | 2 |
| How to resolve -805 error in DB2? | Cap-Gemini | 1 |
| Where is the access path logic created by the DB2 Optimizer
stored? | | 1 |
| What is DCLGEN ? | | 2 |
| What is a subselect? Is it different from a nested select? | | 1 |
| What will the FREE command do to a plan? | | 1 |
| What is a buffer pool? | | 2 |
| Normalization in DB2 – first normal form, second normal form
| Virtusa | 4 |
| If we keep the DCLGEN structure for a table in a copybook
and include it in the COBOL program using the COPY
statement, will there be any impact during compilation or
at any stage of program execution? | | 2 |
| I have 3 cursors declared. Cursor1 retieves some data.
Based on this curso2 will also fetches some data. In cursor3
(using for some updation) I'm using the data retrieved by
the above 2 cursor. My question is, while working with
cursor3, periodically if I give commit, will all the three
crsors will be closed or only cursor3 will be closed? | | 2 |
| What is a result table? | | 1 |
| What is the picture clause of the null indicator variable? | | 5 |
| what is REORG? what is the use? | | 3 |
| What is a view? Why use it? | | 1 |
| what types of copies can be made with the COPY Utility ? | | 1 |
| I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER
DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION
AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT
TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01-
JAN-2007 TO 01-JAN-2008? | Perot-Systems | 5 |
| What is dynamic SQL? | | 1 |
| The only place of VSAM KSDS in DB2 is? | | 2 |
| What is meant by a unit of recovery? | | 1 |
| |
| For more DB2 Interview Questions Click Here |