Multiple choice technology databases

Which one of the following SQL*Plus options lets you trace and print the execution plans as well as statistics?

  1. SET AUTOTRACE TRACEONLY

  2. SET AUTOTRACE ON

  3. SET AUTOTRACE ON STATISTICS

  4. SET AUTOTRACE ON EXPLAIN
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SET AUTOTRACE ON displays both the execution plan (EXPLAIN) and statistics (STATISTICS) for SQL queries. The ON option combines both tracing capabilities. TRACEONLY suppresses query output, ON STATISTICS shows only statistics, and ON EXPLAIN shows only the execution plan - but ON gives you everything.

Keep practicing — related questions