Examine the SQL statement given below:SQL> EXPLAIN PLAN for -SELECT department_name,count(*)FROM hr.employees e, hr.depa
Posted: Sun Jun 11, 2023 3:49 pm
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.)
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.
- Examine The Sql 1 (143.38 KiB) Viewed 285 times
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.