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?
A. RUNSTATS ON TABLE employee USE PROFILE
B. RUNSTATS ON TABLE employee USE SAMPLED INDEX emp_ind1
C. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED DETAILED INDEXES ALL
D. RUNSTATS ON TABLE employee WITH DISTRIBUTION AND SAMPLED INDEX emp_ind1 GENERATE PROFILE
|
Download Printable PDF. VALID exam to help you PASS. |
 |