Which of the following can be used to remove an index that currently exists on the column of a database table?
A) ALTER TABLE...DROP
B) ALTER TABLE...MODIFY
C) DROP INDEX
D) DELETE INDEX

Question

Which of the following can be used to remove an index that currently exists on the column of a database table?​
A) ​ALTER TABLE...DROP
B) ​ALTER TABLE...MODIFY
C) ​DROP INDEX
D) ​DELETE INDEX

Quizplus · Accepted Answer

The correct syntax to remove an index in a database table is to use the "DROP INDEX" statement. The other options are not valid syntax for this action.

Which of the Following Can Be Used to Remove an Index