Home » MCQs » SQL MCQs » SQL Basics (Set 2) MCQs

What does the CREATE INDEX Statement do?

19. What does the CREATE INDEX Statement do?

1. An index is created in a SQL database table with this SQL statement.
2. Changes made in the SQL database transaction are permanently saved using this SQL statement.
3. By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
4. The SQL database table's index is deleted using this SQL statement.

Answer: A) An index is created in a SQL database table with this SQL statement

Explanation:

An index is created in a SQL database table with CREATE INDEX SQL statement.