| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| A Table feild is declared as Decimal(7,2). I want to insert
the decimal in to this column thru cobol-db2 program.
How should I declare my local input file variable
or any suggestion? | IBM | 6 |
| I need to view the number of tables existing under one
particular Owner. Is it possible? If so, pl give the SQL
query for this? | | 3 |
| In a DB2-CICS program which is acts as co-ordinator and
which is participant? | | 1 |
| What does the CHECK Utility do ? | | 1 |
| Which catalog tables contain authorization information? | | 1 |
| How many sub queries can you combine together ? | | 1 |
| What is a clustered index? | | 1 |
| what types of copies can be made with the COPY Utility ? | | 1 |
| What are the isolation levels possible ? | | 2 |
| What does CURRENTDATA option in bind indicate | | 1 |
| Lot of updates have been done on a table due to which
indexes have gone haywire. What do you do? | | 1 |
| Where besides the DB2 catalog is database object
information stored by DB2? | | 1 |
| What is Skeleton cursor table (SKCT)? | | 1 |
| Name the different types of Table spaces. | | 2 |
| Where is the access path logic created by the DB2 Optimizer
stored? | | 1 |
| What is cursor stability? | | 1 |
| In which column of which DB2 catalog would you find the
length of the rows for all tables? | | 1 |
| insert into tablename a
column1,
column2
select column1,
column2
from tablename b
i am getting abend -104..can any one help? | Syntel | 3 |
| Where would you find information about the type of database
authority held by the user? | | 2 |
| Can we use select * statement in cobol program without
giving field names ??? | Zensar | 2 |
| |
| For more DB2 Interview Questions Click Here |
Site Map
