Given the following statements have been run successfully and the buffer pools BP1 and BP2 both
have the same page size: CREATE TABLESPACE TS1 IN DB1 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 on
COL1 on TB1?

A.
ALTER TABLESPACE TS1
MAXPARTITIONS 15;

B.
COMMIT;

C.
CREATE INDEX IX1 ON TB1
(COL1);

D.
REORG TABLESPACE TS1;

Explanation: