Which SQL command correctly displays the execution plan for the query SELECT * FROM employees; in MySQL?

easy📝 Syntax Q3 of 15

SQL - Indexes and Query Performance

Which SQL command correctly displays the execution plan for the query SELECT * FROM employees; in MySQL?

APLAN SELECT * FROM employees;

BSHOW PLAN FOR SELECT * FROM employees;

CEXPLAIN SELECT * FROM employees;

DDESCRIBE EXECUTION SELECT * FROM employees;

Step-by-Step Solution

Solution:

Step 1: Recall MySQL syntax
In MySQL, the EXPLAIN keyword before a SELECT statement shows the execution plan.
Step 2: Evaluate options
Only EXPLAIN SELECT * FROM employees; uses the correct syntax; others are invalid or unsupported commands.
Final Answer:
EXPLAIN SELECT * FROM employees; -> Option C
Quick Check:
MySQL uses EXPLAIN before SELECT [OK]

Quick Trick: Use EXPLAIN before SELECT in MySQL [OK]

Common Mistakes:

Master "Indexes and Query Performance" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes