Oracle
1Z0-882 · Question #22
Inspect the query: Mysql>SELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE dept_no'd004'; 4 rows in set (0.00 sec) Mysql>EXPLAIN SELECT dept_no, emp_no FROM employees JOIN…
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #22. The question stem and answer options stay visible for context.
Question
Inspect the query:
Mysql>SELECT dept_no, emp_no FROM employees JOIN dept _manager USING(emp_no) WHERE dept_no'd004'; 4 rows in set (0.00 sec) Mysql>EXPLAIN SELECT dept_no, emp_no FROM employees JOIN dept_manager USING (emp_no) WHERE dept_no='d004'; 2 rows in set (0.00 sec) Which two statements are true about the EXPLAIN output?
Exhibit
Options
- AAll data for the result is read from the indexex.
- BThe PRIMARY KEY is used for filtering in both tables.
- CThe minimal number of rows possible are read.
- DThe dept_manager table has 4 times as many rows than 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.