Given that the following table (TB1) has been created with this statement: CREATE TABLE TB1 (COLA SMALLINT NOT NULL WITH DEFAULT ,COLB CHAR(5) NOT NULL WITH DEFAULT) IN DB1.TS1; Which of the following statements, which alter a table (TB1), will NOT invalidate all the plans, packages and dynamic cache statements associated with the table TB1?
- A: ALTER TABLE TB1 AUDIT CHANGES;
- B: ALTER TABLE TB1 ADD COLUMN COLC DATE;
- C: ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;
- D: ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS SECURITY LABEL;