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

Previous-Page 1 2 3 4 5 6 7 8 9. . . 15 16 Next-Page

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