Multiple choice technology databases

The execution plan of the SQL statement is stored in

  1. A flat file called "plan_table.txt"

  2. Oracle Table called "plan_table"

  3. Oracle Table called "plan table"

  4. A flat file called "plan_table.tbl"
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Oracle, EXPLAIN PLAN results are written by default to a table named "plan_table" (with an underscore), not to flat files or space-separated names like "plan table". This allows querying and formatting of execution plans using DBMS_XPLAN.

Keep practicing — related questions