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

What does the DROP INDEX Statement do?

20. What does the DROP INDEX Statement do?

1. By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
2. The SQL database table's index is deleted using this SQL statement.
3. An index is created in a SQL database table with this SQL statement.
4. An existing SQL database is selected with this SQL statement. A database must be selected from several existing databases before you can perform operations on the table.

Answer: B) The SQL database table's index is deleted using this SQL statement

Explanation:

The SQL database table's index is deleted using DROP INDEX SQL statement.