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;
Explanation: