PrepAway - Latest Free Exam Questions & Answers

Which command will create a statistics profile on the EMPLOYEE table?

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?

PrepAway - Latest Free Exam Questions & Answers

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

One Comment on “Which command will create a statistics profile on the EMPLOYEE table?


Leave a Reply