ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

The statement used to remove indexes on tables is . . . . . . . .

Answer & Solution
Correct Answer: Option A
This question asks about how to get rid of indexes on a table in MySQL. Indexes help your database find information quickly, but sometimes you might need to remove them.

Let's look at the options:

Option A: DROP INDEX - This is the correct answer! You use `DROP INDEX` to delete an index from a table.

Option B: DELETE INDEX - This is incorrect. `DELETE` is used to remove rows from a table, not indexes.

Option C: REMOVE INDEX - This is also incorrect. MySQL doesn't have a command called `REMOVE INDEX`.

Option D: FLUSH INDEX - This is incorrect. `FLUSH INDEX` is used to refresh the index cache, not delete indexes.

So, the answer is Option A: DROP INDEX.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.