You executed the following statements: Which two statements are true about the query execution?

Question

Exhibit

Options

• AThe execution plan is generated and fetched from the library cache.
• BThe query executes and displays the execution plan and statistics.
• CThe query executes and inserts the execution plan in PLAN_TABLE.
• DThe query executes and execution plan is stored in the library cache and can be viewed using v$SQL_PLAN.
• EThe query will always use the plan displayed by the AUTOTRACE output.

• A
  4% (1)
• B
  83% (19)
• D
  13% (3)

Explanation

B: set autotrace traceonly: Displays the execution plan and the statistics (as set autotrace on does), but doesn't print a query's result. Autotrace can be configured to run the SQL & gives a plan and statistics afterwards or just give you an explain plan without executing the query. To achieve this use the following: * Explain only set autotrace traceonly explain * Execute with stats and explain plan set autotrace on explain stat (with data returned by query) or autotrace traceo expl stat (without data returned by query) * To make the output from an autotrace more readable col plan_plus_exp format a100 * Turn off autotrace set autotrace off / V$SQL_PLAN contains the execution plan information for each child cursor loaded in the library

No community discussion yet for this question.