Examine the SQL statement given below:SQL> EXPLAIN PLAN for -SELECT department_name,count(*)FROM hr.employees e, hr.departments dWHERE e.department_id=d.department_idGROUP 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 1 (143.38 KiB) Viewed 145 times
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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!