Oracle
1Z0-882 · Question #36
1Z0-882 Question #36: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #36. The question stem and answer options stay visible for context.
Question
Inspect the query: Mysql> SELECT count (emp_no) FROM titles WHERE title = `senior staff'; How can this query be optimized?
Exhibit
Options
- AThe query need an index on the emp-no column.
- BThe query cannot be optimized as an index is already used.
- CThe query needs an index that includes the title column.
- DThe query cannot be optimized as count () must read all rows.
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 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.