SQL Indexes MCQ Performance Optimization Practice Questions

Direction: Choose the correct option

What is an index in SQL?

A. Performance optimization structure

B. Table constraint

C. Data type

D. View definition

Direction: Choose the correct option

CREATE INDEX idx_email ON employees(email);

What does this do?

A. Creates view

B. Creates table

C. Creates index on email column

D. Creates new column

Direction: Choose the correct option

CREATE UNIQUE INDEX idx_emp_id ON employees(emp_id);

What does UNIQUE do?

A. Prevents duplicate values

B. Creates primary key

C. Sorts data

D. Speeds up queries

Direction: Choose the correct option

How do you see all indexes on a table?

A. SELECT INDEXES

B. LIST INDEX

C. DESCRIBE INDEX

D. SHOW INDEX FROM

Direction: Choose the correct option

How do you remove an index?

A. DROP INDEX

B. DELETE INDEX

C. REMOVE INDEX

D. ALTER INDEX

Quipoin Menu