| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What will the COMMIT accomplish? | | 4 |
| What is the purpose of the DSNC transaction ? | | 1 |
| What's the maximum number of characters that a tablename
can have? | | 2 |
| What DB2 Catalog column tell you when an index needs table
reorganized ? | | 1 |
| What is REORG? When is it used? | | 1 |
| why should we bind the DB2 program . What if we did not
BIND a BD2 program ?? | Xansa | 5 |
| How do you insert a record with a nullable column? | | 2 |
| what is datacom db? | CSC | 1 |
| Where are plans stored? | | 2 |
| What is tablespace? | | 2 |
| What does the REORG Utility do? | | 1 |
| What is buffrpool? Where we use it ? | Tesco | 2 |
| What is a Database Request Module(DBRM)? | | 2 |
| What is a data page? | | 1 |
| what's the error code for Unique Index Violation? | | 2 |
| what types of copies can be made with the COPY Utility ? | | 1 |
| What is a DBRM, PLAN ? | | 1 |
| What is a lock? | | 1 |
| What do you need to do before you do EXPLAIN? | | 1 |
| which SQL comment successfully removes uncommitted changes
from a DB2 database
A) rollback
B) delete
C) drop
D) decommit
| Accenture | 1 |
| |
| For more DB2 Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
