Oracle
1Z0-054 · Question #13
1Z0-054 Question #13: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
Question
Examine the SQL statement given below: SQL> EXPLAIN PLAN for SELECT department_name,count(*) FROM hr.employees e, hr.departments d WHERE e.department_id=d.department_id GROUP BY d.department_name; To view the execution plan for the statement, you queried plan_table. View the Exhibit and examine the execution plan. Which two statements are true about the execution plan? (Choose two.)
Exhibit
Options
- AThe execution plan is displayed for the executed SQL statement.
- BThe EXPLAIN PLAN command does not actually execute the statement.
- CThe row with the id column having a value of 4 is the first step executed in the execution plan.
- DThe row with the id column having a value of 0 is the first step executed in the execution plan.
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 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.