PrepAway - Latest Free Exam Questions & Answers

Category: C2090-311

Exam C2090-311: IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1

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?


Page 2 of 3123