Which are the two ways of retrieving the execution plan for an SQL statement?

  1. select * from utlxplan;

  2. select * from plan_table;

  3. select plan from plan_table;

  4. select * from table(dbms_xplan.display);


Correct Option: B,D

Find more quizzes: