| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| we can code COPY DCLGEN or INCLUDE DCLGEN,
At which stage of the precompilation , dclgen get expanded
if we write 1) copy
2) include
one question about dclgen..
Is it mandatory to use declare table in dclgen..
I think no...but
it will be used by the precompiler to validate the table
name,column name etc..,
can one clear my doubt ..is it necessary to include
declare table or not?
| | 2 |
| What is the format (internal layout) of ?TIMESTAMP?? | | 1 |
| What is DCLGEN ? | | 2 |
| Which transaction use a command thread ? | | 1 |
| What error I will get if my select query gives multiple
row while executing a Cobol-DB2 program.How can I solve it
without using a cursor.
| Cap-Gemini | 4 |
| How many sub queries can you combine together ? | | 4 |
| How many clustering indexes can be defined for a table? | | 1 |
| What is correlation names? | | 1 |
| Is it mandatory to use DCLGEN? If not, why would you use it
at all? | | 2 |
| What are the 4 environments which can access DB2 ? | | 2 |
| what types of copies can be made with the COPY Utility ? | | 1 |
| What are the disadvantages of using VARCHAR? | | 3 |
| What is a host variable? | | 1 |
| What are PACKAGES ? | | 3 |
| How will you delete duplicate records from a table? | | 3 |
| What is the self-referencing constraint? | | 1 |
| What is isolation level? | | 1 |
| What is RUNSTATS? | | 3 |
| Explain an outer join? | | 1 |
| What is Reorg Recovery? when will you run it? | | 1 |
| |
| For more DB2 Interview Questions Click Here |