100% Pass Guarantee with IBM C2090-614 Dumps!

A table named MYTAB was created as follows:

How many rows will be inserted into the MYTAB table?

A. 4

B. 8

C. 11

D. 12

Given the following output:

Which Explain procedure can be used to find the most expensive SQL statement in terms of CPU cost over a period of time?

A. EXPLAIN_FROM_DATA

B. EXPLAIN_FROM_ACTIVITY

C. EXPLAIN_FROM_SECTION

D. EXPLAIN_FROM_CATALOG

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?

A. ALTER TABLESPACE ts1 REBALANCE

B. ALTER STOGROUP med_sg ADD db2fs5ALTER STOGROUP med_sg ADD db2fs5

C. ALTER STOGROUP med_sg DROP '/db2fs4'

D. ALTER TABLESPACE ts1 ADD '/db2fs4' REBALANCE