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- C2090-612





Question ID 20476

In determining whether a REORG on an index space would improve performance, which
two of the following columns would NOT be needed? (Choose two.)

Option A

Column CLUSTERING in SYSIBM.SYSINDEXES

Option B

Column LEAFDIST in SYSIBM.SYSINDEXPART

Option C

Column CLUSTERRATIOF in SYSIBM.SYSINDEXES

Option D

 Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS

Option E

 Column LASTUSED in SYSIBM.SYSINDEXSPACESTATS

Correct Answer A,D
Explanation


Question ID 20477

The available window to reorganize table spaces is being reduced. What data can provide
information to allow for a priority list of candidate table spaces for reorganization based on
recentactivity with no recent RUNSTATS execution?

Option A

SYSIBM.SYSCOPY

Option B

 SYSIBM.SYSTABLES

Option C

SYSIBM.SYSINDEXES

Option D

SYSIBM.SYSTABLESPACESTATS

Correct Answer D
Explanation

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