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

Given the following statements have been run successfully and the buffer pools BP1 and BP2 both have the same page size: CREATE TABLESPACE TS1 INDB1 DEFINE YES BUFFERPOOL BP1 MAXPARTITIONS 15 MEMBER CLUSTER ; CREATE TABLE TB1 (COL1 INT NOT NULL WITH DEFAULT) IN DB1.TS1 ;COMMIT ; ALTER TABLESPACE TS1 BUFFERPOOL BP2 MAXPARTITIONS 20 ; What is the next logical step in the sequence to CREATE an index IX1 onCOL1 on TB1?

1. A. ALTER TABLESPACE TS1 MAXPARTITIONS 15;
2. B. COMMIT;
3. C. CREATE INDEX IX1 ON TB1 (COL1); — đáp án hiện tại
4. D. REORG TABLESPACE TS1;