AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For IBM- 000-611





Question ID 19943

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?

Option A

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

Option B

ALTER TABLEPACE my_ts MANAGED BY DATABASE;ALTER TABLESPACE my_ts MANAGED BY
AUTOMATIC STORAGE;ALTER TABLESPACE my_ts REBALANCE;

Option 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;

Option 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;

Correct Answer A
Explanation


Question ID 19944

Which statement about range-clustered tables is true?

Option A

Range-clustered tables can be used with the REORG utility.

Option B

Range-clustered tables can be used with multiple-column keys.

Option C

Range-clustered tables can be used in a DB2 pureScale environment.

Option D

Range-clustered tables can be used with value and default compression.

Correct Answer B
Explanation

Send email to admin@getfreedumps for new dumps request!!!