What happens to the PLAN if index used by it is

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What happens to the PLAN if index used by it is dropped?

Plan is marked as invalid. The next time the plan is accessed, it is rebound.

(Continued on next question...)

Other Job Interview Questions

• How do you read vsam file?
• What are correlated subqueries?
• What else is there in the PLAN apart from the access path? –
• What is FREEPAGE and PCTFREE in TABLESPACE creation?
• How do I create a table MANAGER ( EMP#, MANAGER) where MANAGER is a foreign key which references to EMP# in the same table? Give the exact DDL.
• What is the COBOL picture clause of the following DB2 data types:
• EXPLAIN has output with MATCHCOLS = 0. What does it mean? –
• What are aggregate functions?
• What is QUIESCE?
• Name some fields from SQLCA.
• More...