Oracle
1Z0-054 · Question #13
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…
The correct answer is B. The EXPLAIN PLAN command does not actually execute the statement. C. The row with the id column having a value of 4 is the first step executed in the execution plan. See the full explanation below for the reasoning.
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.
How the community answered
(41 responses)- A17% (7)
- B76% (31)
- D7% (3)
Community Discussion
No community discussion yet for this question.