IBM
A2090-614 · Question #45
A2090-614 Question #45: Real Exam Question with Answer & Explanation
Sign in or unlock A2090-614 to reveal the answer and full explanation for question #45. The question stem and answer options stay visible for context.
Question
The following query is executed frequently against the EMPLOYEE table: SELECT empid, salary, bonus FROM employee ORDER BY bonus, salary; Which statement will create an index for optimal query performance?
Options
- ACREATE INDEX salary_bonus_idx ON employee (salary, bonus)
- BCREATE INDEX bonus_salary_idx ON employee (bonus, salary)
- CCREATE INDEX bonus_salary_idx ON employee (bonus, salary) CLUSTER
- DCREATE INDEX salary_bonus_idx ON employee (salary, bonus) CLUSTER
Unlock A2090-614 to see the answer
You've previewed enough free A2090-614 questions. Unlock A2090-614 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.