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-311





Question ID 20863

Which statement about expression-based indexes is true?

Option A

 The RUNSTATS command cannot be used to collect statistics for expression-based indexes.

Option B

Expression-based indexes must always be defined as UNIQUE to prevent duplicate index keys.

Option C

Expression-based index keys consist of a concatenation of one or more specified table columns.

Option D

 The index key values of expression-based indexes are not the same as the values in the corresponding table columns.

Correct Answer D
Explanation


Question ID 20864

An expression-based index named EMPJND1 and a statistical view named EMP_IND1_V
have been created for a table named EMPLOYEE.
If the following command is used to set up a statistics profile on the statistical view
EMP_IND1_V:
RUNSTATS ON VIEW emp_ind1_v WITH DISTRIBUTION DEFAULT UM_FREQVALUES
50 SET PROFILE ONLY
Which command will create a statistics profile on the EMPLOYEE table?

Option A

RUNSTATS ON TABLE employee USE PROFILE

Option B

 RUNSTATS ON TABLE employee USE SAMPLED INDEX emp_ind1

Option C

RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL

Option D

RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED INDEX emp_ind1 GENERATE PROFILE

Correct Answer C
Explanation

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