The following DDL statements are executed to create the following objects: CREATE
TABLESPACE TS1 BUFFERPOOL BP0 IN DB1; CREATE TABLE USER1.TB1 ( COL1
INTEGER, COL2 VARCHAR(10) ) IN DB1.TS1; CREATE INDEX USER1.IX1 ON USER1.TB1 (
COL2 ) BUFFERPOOL BP0 COPY YES; Next, the following ALTER statements are done (in
order): 1) ALTER TABLESPACE DB1.TS1 BUFFERPOOL BP8K0 MAXPARTITIONS 20; 2)
ALTER TABLESPACE DB1.TS1 SEGSIZE 64; 3) ALTER INDEX USER1.IX1 BUFFERPOOL
BP16K0; Which of the following will materialize all of the changes with the least amount of work?

A.
Nothing needs to be done.

B.
REORG INDEX USER1.IX1 SHRLEVEL CHANGE

C.
REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE

D.
REORG TABLESPACE DB1.TS1 SHRLEVEL REFERENCE
REORG INDEX USER1.IX1 SHRLEVEL CHANGE

Explanation: