Which SQL statement correctly creates a covering index on columns user_id and email in a table users?

easy📝 Syntax Q3 of 15

SQL - Indexes and Query Performance

Which SQL statement correctly creates a covering index on columns user_id and email in a table users?

ACREATE INDEX idx_user_email FROM users(user_id, email);

BCREATE TABLE idx_user_email ON users(user_id, email);

CCREATE INDEX idx_user_email IN users(user_id, email);

DCREATE INDEX idx_user_email ON users(user_id, email);

Step-by-Step Solution

Solution:

Step 1: Recall correct syntax for creating an index
The correct syntax is CREATE INDEX index_name ON table_name(columns).
Step 2: Match syntax with options
CREATE INDEX idx_user_email ON users(user_id, email); matches the correct syntax exactly.
Final Answer:
CREATE INDEX idx_user_email ON users(user_id, email); -> Option D
Quick Check:
CREATE INDEX syntax = ON [OK]

Quick Trick: Use ON keyword to specify table when creating index [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