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.
c
a and b are true
BC
Mateo is correct, B and C are right.
Aplatoniclover did not read the question and see it requires 2 answers.
Hari is wrong with (a), EXPLAIN PLAN only forms an execution plan and saves it to the PLAN_TABLE. It does not execute the query.
Anybody taking exam in 2016?