You executed the following statement: Which three statements are true about EXPLAIN PLAN?

Question

Exhibit

Options

• AThe execution plan is saved in PLAN_TABLE without executing the query.
• BThe execution plan for the query is generated and displayed immediately as the output.
• CThe execution plan generated may not necessarily be the execution plan used during query execution.
• DThe execution plan is saved in DBA_HIST_SQL_PLAN without executing the query.
• EThe execution plan generated can be viewed using the DBMS_XPLAIN.DISPLAY function.
• FThe execution plan generated can be fetched from the library cache by using the DBMS_XPLAIN.DISPLAY

• A
  81% (30)
• B
  11% (4)
• D
  5% (2)
• F
  3% (1)

Explanation

• (A, not D): The explain plan process stores data in the PLAN_TABLE. The EXPLAIN PLAN method doesn't require the query to be run (A), greatly reducing the time it takes to get an execution plan for long-running queries compared to AUTOTRACE. E: Use the DBMS_XPLAN.DISPLAY function to display the execution plan. * The DBMS_XPLAN package provides an easy way to display the output of the EXPLAIN PLAN command in several, predefined formats. You can also use the DBMS_XPLAN package to display the plan of a statement stored in the Automatic Workload Repository (AWR) or stored in a SQL tuning set. It further provides a way to display the SQL execution plan and SQL execution runtime statistics for cached SQL cursors based on the information stored in the V$SQL_PLAN and V$SQL_PLAN_STATISTICS_ALL fixed views.

No community discussion yet for this question.