Which of the following statements should you use to accomplish the task?

You work as a Database Administrator for Domain.com. The company uses MySQL as its
database. The database contains a table named Employees. You want to remove an index named
Emp_name_idx from the Employees table. Which of the following statements should you use to

accomplish the task?

A.
DELETE INDEX Emp_name_idx;

B.
CANCEL INDEX Emp_name_idx;

C.
REMOVE INDEX Emp_name_idx;

D.
DROP INDEX Emp_name_idx;