Multiple choice technology databases

Which of the following generates the PLAN for SQL statements?

  1. PLAN

  2. EXPLAIN PLAN

  3. TKPROF
  4. V$PLAN
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

EXPLAIN PLAN is the SQL command that generates and displays the execution plan for a SQL statement without actually executing it. PLAN is not a valid command, TKPROF is a profiling tool for analyzing trace files, and V$PLAN is not a valid dynamic performance view.

Keep practicing — related questions