adplus-dvertising
frame-decoration

Question

The statement used to remove indexes on tables is ______________

a.

DROP INDEX

b.

DELETE INDEX

c.

REMOVE INDEX

d.

FLUSH INDEX

Posted under MySQL Database

Answer: (a).DROP INDEX

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 __________

Q. What is the general term for information about databases and the objects in MySQL?

Q. Perl scripts are text files.

Q. The shebang line is ______________

Q. The Perl DBI is ______________

Q. The default path to perl in Unix is ______________

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?

Q. What is the facility that allows nesting one select statement into another?

Q. Which of these operators does not perform relative value comparisons?

Q. To combine multiple retrievals, which keyword is used to write several SELECT statements between them?

Q. Issuing ‘SELECT’ on a MERGE table is like _____________

Q. In Perl DBI, functions are called ______________

Q. Which variable is used as a handle to an open file?

Q. The variable that is a handle to a database object is ______________

Q. Which variable returns code from operations that return true or false?

Q. The statement to remove indexes on tables is ______________

Q. What allows nesting one select statement into another?

Q. The operator that does not perform relative-value comparisons is ______________

Q. The key declares that an index in one table is related to that in another is called _____________

Q. Foreign keys can handle deletes and updates.