Multiple choice technology databases

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);
Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

Oracle provides two primary methods for retrieving execution plans: querying the PLAN_TABLE directly (which stores the plan) or using the DBMS_XPLAN.DISPLAY function for formatted output. The utlxplan view is outdated, and plan_table requires specific column selection.

Keep practicing — related questions