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

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 5

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


aplatoniclover

aplatoniclover

c

Hari

Hari

a and b are true

Rodge

Rodge

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.

domq

domq

Anybody taking exam in 2016?