Category: 1Z0-054

Exam 1Z0-054: Oracle Database 11g, Performance Tuning

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:


Page 1 of 1912345...10...Last »