Oracle
1Z0-882 · Question #93
Inspect the SELECT query: Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date > `2008-10-11'; Guaranteed success with TestInsides practice guides…
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #93. The question stem and answer options stay visible for context.
Question
Inspect the SELECT query:
Mysql> EXPLAIN SELECT employees. Emp_no, first_name, last_name FROM employees JOIN title WHERE to_date > `2008-10-11'; Guaranteed success with TestInsides practice guides 14 2 rows in set (0.00 sec) Which action will optimize the query?
Exhibit
Options
- AAdd an index to the employees. emp _no column.
- BAdd the keyword STRAIGHT_JOIN.
- CAdd an index on the to_ date column.
- DAdd the FORCE INDEX (PRIMARY) optimizer hint for the employees table.
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.