| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the command used by TSO users to invoke DB2? | | 1 |
| Describe the elements of the SELECT query syntax? | | 3 |
| What is the FREE command? | | 1 |
| What is a DB2 catalog? | | 2 |
| What is DB2 (IBM Database 2)? | | 1 |
| What is pagespace? | | 1 |
| What is the physical storage length of each of the
following DB2 data types: DATE, TIME, TIMESTAMP? | CTS | 1 |
| what types of copies can be made with the COPY Utility ? | | 1 |
| Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time? | | 1 |
| What is a DB2 access path? | | 1 |
| What information can you find in SYSIBM.SYSLINKS table? | TCS | 1 |
| What does the sqlcode of -818 pertain to? | | 2 |
| What is QUIESCE? | | 2 |
| 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 are extents? | | 3 |
| What are leaf pages? | | 1 |
| The only place of VSAM KSDS in DB2 is? | | 2 |
| What do you need to do before you do EXPLAIN? | | 1 |
| What is cursor stability? | | 1 |
| What are the levels of isolation available with DB2V4 | | 1 |
| |
| For more DB2 Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map