PrepAway - Latest Free Exam Questions & Answers

Which statements will enable automatic storage in stora…

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?

PrepAway - Latest Free Exam Questions & Answers

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;


Leave a Reply