Which statements will enable automatic storage in storage group SG_HOT for a given
database managed table space MY_TS and remove all existing non-automatic storage
containers from the table space?

A.
ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE; ALTER
TABLESPACE my_ts REBALANCE;

B.
ALTER TABLEPACE my_ts MANAGED BY DATABASE; ALTER TABLESPACE my_ts

MANAGED BY AUTOMATIC STORAGE; ALTER TABLESPACE my_ts REBALANCE;

C.
ALTER TABLESPACE my_ts MANAGED BY AUTOMATIC STORAGE USE
STOGROUP sg_hot; ALTER STOGROUP sg_hot DROP ‘/db2/filesystem1’,
‘/db2/filesystem2’; ALTER TABLESPACE my_ts REBALANCE;

D.
ALTER TABLESPACE my_ts MANAGED BY DATABASE USE STOGROUP sg_hot;
ALTER STOGROUP sg_hot DROP ‘/db2/filesystem1’, ‘/db2/filesystem2’; ALTER
TABLESPACE my_ts REBALANCE;