Q. What does the DROP INDEX Statement do?
-
(A)
The SQL database table's index is deleted using this SQL statement.
-
(B)
By running this SQL statement, the transaction will be undone and the operations not yet saved to the SQL database will be undone.
-
(C)
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.
-
(D)
An index is created in a SQL database table with this SQL statement.
✅ Correct Answer: (A)
The SQL database table's index is deleted using this SQL statement.