Question
a.
DROP INDEX
b.
DELETE INDEX
c.
REMOVE INDEX
d.
FLUSH INDEX
Posted under MySQL Database
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. The statement used to remove indexes on tables is ______________
Similar Questions
Discover Related MCQs
Q. The statement used to change the table name is __________
View solution
Q. What is the general term for information about databases and the objects in MySQL?
View solution
Q. Perl scripts are text files.
View solution
Q. The shebang line is ______________
View solution
Q. The Perl DBI is ______________
View solution
Q. The default path to perl in Unix is ______________
View solution
Q. Which is the join in which all the rows from the right table appear in the output irrespective of the content of the other table?
View solution
Q. What is the facility that allows nesting one select statement into another?
View solution
Q. Which of these operators does not perform relative value comparisons?
View solution
Q. To combine multiple retrievals, which keyword is used to write several SELECT statements between them?
View solution
Q. Issuing ‘SELECT’ on a MERGE table is like _____________
View solution
Q. In Perl DBI, functions are called ______________
View solution
Q. Which variable is used as a handle to an open file?
View solution
Q. The variable that is a handle to a database object is ______________
View solution
Q. Which variable returns code from operations that return true or false?
View solution
Q. The statement to remove indexes on tables is ______________
View solution
Q. What allows nesting one select statement into another?
View solution
Q. The operator that does not perform relative-value comparisons is ______________
View solution
Q. The key declares that an index in one table is related to that in another is called _____________
View solution
Q. Foreign keys can handle deletes and updates.
View solution
Suggested Topics
Are you eager to expand your knowledge beyond MySQL Database? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!