| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| pls tell me abt the normalization five types.... | | 1 |
| What are the contents of a DCLGEN? | MetLife | 2 |
| What is the purpose of the QUIESE Utility? | | 1 |
| What are the levels of isolation available with DB2V4 | | 1 |
| What statistic will tell the DBA how must space can be
reclaimed from dropped table spaces on the next reorg run? | | 1 |
| i want to know how the commit option works,how it save the
changes? it will update the database or what ? where we can
see these saved changes? | | 2 |
| What is image copy? | Virtusa | 1 |
| What will the DB2 optimizer do? | | 1 |
| What is the syntax of SELECT statement when embedded in a
COBOL program? | | 2 |
| Is it Possible to read from PS file and write it to
database by using dynamic sql(execute immediate) | | 2 |
| How do you declare a host variable (in COBOL) for an
attribute named emp-name of type VARCHAR(25) ? | | 2 |
| What are column-name qualifiers used? | | 1 |
| How many Buffer pools are there in DB2 and what are they? | | 1 |
| What is a clustering index ? | | 3 |
| AGGREGATE function support by DB2.
A) SUM & AVG
B) SUM, MIN & AVG
C) SUM, MAX, AVG , MIN &COUNT
D) NONE
| Accenture | 1 |
| How to resolve -805 error in DB2? | Cap-Gemini | 1 |
| Explain an outer join? | | 1 |
| If the base table underlying a view is restructured, eg.
attributes are added, does the application code accessing
the view need to be redone? | | 2 |
| What is DCLGEN ? | | 2 |
| How to update more then one record using update? | IBM | 4 |
| |
| For more DB2 Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
