Multiple choice technology databases

Which tool is used to analyze access path of SQL statement?

  1. Exp

  2. Imp

  3. Explain Plan

  4. vi Editor
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

EXPLAIN PLAN is the SQL command used to analyze and display the execution path that Oracle's optimizer will use for a SQL statement. 'Exp' and 'Imp' are import/export utilities, and 'vi' is a text editor - none analyze SQL access paths.

Keep practicing — related questions