1.

The statement to remove indexes on tables is ______________(a) DROP INDEX(b) DELETE INDEX(c) REMOVE INDEX(d) FLUSH INDEXI got this question during an interview for a job.The query is from Perl DBI Overview in chapter MySQL Programs Using Perl DBI and PHP of MySQL

Answer»

Correct ANSWER is (a) DROP INDEX

Explanation: MYSQL PROVIDES statements to change the structure of tables. To add or remove the indexes on the EXISTING database tables, the ‘CREATE INDEX’ and ‘DROP INDEX’ tables are used.



Discussion

No Comment Found

Related InterviewSolutions