| Other DB2 Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How do you simulate the EXPLAIN of an embedded SQL
statement in SPUFI/QMF? Give an example with a host
variable in WHERE clause) | | 1 |
| What is cursor stability? | | 1 |
| How many clustering indexes can be defined for a table? | | 1 |
| What information is held in SYSIBM.SYSCOPY? | | 1 |
| Under what circumstances will DB2 allow an SQL statement to
update more than one primary key value at a time? | | 1 |
| When can an insert of a new primary key value threaten
referential integrity? | | 1 |
| What is the cascade rule and how does it relate to
deletions made with a subselect? | | 1 |
| Once you create a view, where would information about the
view be stored? | | 1 |
| How would you print the output of an SQL statement from
SPUFI? | | 1 |
| How to define the data items to receive the fetch items for
the SQL? | | 1 |
| what needs to be done if a table is in copy pending / check
pending status? | Xansa | 4 |
| how many partitions are possible in partitioned tablespace?
dont say 1-64.
a)240
b)256
c)512
d)none | AMDOC | 6 |
| What do the initials DDL and DML stand for and what is
their meaning? | | 1 |
| Where are plans stored? | | 2 |
| What is tablespace? | | 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 is the purpose of the DSNC transaction ? | | 1 |
| I am getting a error multiple row fetched while executing a
Cobol-DB2 program.How can I solve it without using a cursor. | | 4 |
| What is a DB2 bind? | | 2 |
| Is there any advantage to denormalizing DB2 tables? | | 1 |
| |
| For more DB2 Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map