If the following statements are executed: CREATE STOGROUP sg_hot ON ‘/path1’, ‘/path2’,
‘/path3’; CREATE STOGROUP sg_med ON ‘/path4’, ‘/path5’, ‘/path6’; CREATE TABLESPACE
tbsp1 USING STOGROUP sg_hot; What is the recommended way to move table space TBSP1
from storage group SG_HOT to storage group SG_MED?

A.
Issue an ALTER TABLESPACE statement with the ‘USING sg_med’ option.

B.
Issue an ALTER STOGROUP statement with the ‘MOVE tbsp1 TO sg_med’ option.

C.
Perform a table space RESTORE operation with the ‘USING STOGROUP sg_hot’ option.

D.
Use the ADMIN_MOVE_TABLESPACE procedure to move table space TBSP1 to SG_HOT.

Explanation: