Which two statements are true about the execution plan?

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.)

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.)

A.
The execution plan is displayed for the executed SQL statement.

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.

D.
The row with the id column having a value of 0 is the first step executed in the execution plan.



Leave a Reply 1

Your email address will not be published. Required fields are marked *


L. Zhu

L. Zhu

explain plan does not actually execute the statement
higher number executed first

So B.C