| 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 do the initials DDL and DML stand for and what is
their meaning? | | 1 |
| What is the maximum number of tables that can be stored on
a Partitioned Table Space ? | | 1 |
| What techniques will be used to avoid deadlock?? | | 1 |
| What is meant by repeatable read? | | 1 |
| How do you filter out the rows retrieved from a Db2 table ? | | 1 |
| When do you specify the isolation level? How? | | 1 |
| What is correlation names? | | 1 |
| What is a DBRM, PLAN ? | | 1 |
| what is the process of precompiler? | | 2 |
| What is the significance of DB2 free space and what
parameters control it? | | 1 |
| When would you prefer to use VARCHAR? | | 2 |
| What is lock escalation? | | 1 |
| What are the advantages of using a PACKAGE? | | 2 |
| What is pagespace? | | 1 |
| How are write I/Os from the buffer pool executed? | | 1 |
| What are the isolation levels possible ? | | 2 |
| What is a clustered index? | | 1 |
| What are the four lockable units for DB2? | | 1 |
| What are the various locking levels available? | | 2 |
| |
| For more DB2 Interview Questions Click Here |