Multiple choice

Name the tool for tuning SQL statements.

  1. TUNEUP SYS

  2. EXPLAIN SYS

  3. DB_TUNEUP

  4. EXPLAIN PLAN
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

EXPLAIN PLAN is the Oracle tool used to analyze and display the execution plan SQL statements will use, helping identify performance bottlenecks like full table scans or inefficient joins. The other options (TUNEUP SYS, DB_TUNEUP) are not standard Oracle tools, and EXPLAIN SYS is not a valid tuning command.

Keep practicing — related questions