Câu 27: C2090-612: DB2 10 DBA for zOS

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?

1. A. ALTER TABLE TB1 AUDIT CHANGES;
2. B. ALTER TABLE TB1 ADD COLUMN COLC DATE; — đáp án hiện tại
3. C. ALTER TABLE TB1 RENAME COLUMN COLA TO COLC;
4. D. ALTER TABLE TB1 ADD COLUMN COLC CHAR(8) NOT NULL WITH DEFAULT AS