| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How does one bind 2 versions of a CICS transaction with the
same module name in two different CICS regions that share
the same DB2 subsystem? | | 2 |
| When Can you be sure that a query will return only one row? | | 3 |
| What is JOIN and different types of JOIN. | | 2 |
| What's the maximum number of volumes that can be added to a
STOGROUP? | | 1 |
| When is the access path determined for dynamic SQL? | | 2 |
| What is UNION,UNION ALL? | | 1 |
| What is a cursor? | | 2 |
| What does the RUNSTATS Utility do? | | 4 |
| When is the skeleton cursor table created? | | 1 |
| Are views updatable ? | | 3 |
| What is cursor stability? | | 1 |
| What is the difference between TYPE 1 index & TYPE 2 index | | 1 |
| What do the initials DDL and DML stand for and what is
their meaning? | | 2 |
| how can u understand the end of the table ? | TCS | 1 |
| which authority can be granted to group of users using the
GRANT stmt?
A) SYSCTRL
B) SYSADM
C) DBCTRL
D) DB ADM
| Accenture | 2 |
| pls explain the precompilation process of cobol-db2 pgm | IBM | 1 |
| How we create a tables in DB2 ?Previously client has using
7 letters for user id,now he wants to increase the letters
from 7 to 12 for user id.How we can do it? | Wipro | 5 |
| When you are working with the project after coding what
will u do?
Like what type of documents u will prepare? How will u do
testing?
| | 1 |
| What is an access path? | | 2 |
| What are the different methods of accessing db2 from tso?
How is the connection established between TSO & DB2? | Tech-Mahindra | 3 |
| |
| For more DB2 Interview Questions Click Here |