PrepAway - Latest Free Exam Questions & Answers

A storage group named MED_SG was created as follows: CREATE STOGROUP med_sg ON ?db2fs1? ?db2fs2?

A storage group named MED_SG was created as follows: CREATE STOGROUP med_sg ON
?db2fs1? ?db2fs2? ‘/db2fs3’ Then, a table space named TS1 was created in the storage group
and two tables (TAB_A and TAB_B) were created in the TS1 table space. Four months later, a
DBA discovered that 90% of the space that had been allocated to the MED_SG storage group had
been consumed. So, more space was added to the storage group by executing the following
command: ALTER STOGROUP med_sg ADD ?db2fs4? ALTER STOGROUP med_sg ADD
?db2fs4 Shortly afterwards, queries against tables in the TS1 table space began to run slower.
Which statement should be executed to correct the performance problem?

PrepAway - Latest Free Exam Questions & Answers

A.
ALTER TABLESPACE ts1 REBALANCE

B.
ALTER STOGROUP med_sg ADD ?db2fs5?ALTER STOGROUP med_sg ADD ?db2fs5

C.
ALTER STOGROUP med_sg DROP ‘/db2fs4’

D.
ALTER TABLESPACE ts1 ADD ‘/db2fs4’ REBALANCE

Explanation:


Leave a Reply