The statement used to remove indexes on tables is ______________. – McqOptions

MCQOPTIONS

1.	The statement used to remove indexes on tables is ______________.
A.	DELETE INDEX
B.	FLUSH INDEX
C.	DROP INDEX
D.	REMOVE INDEX
E.	None of these
Answer» D. REMOVE INDEX

Discussion

No Comment Found

Related MCQs

Stored programs refer to stored objects of how many of the following types?functions, procedures, triggers, events
How many of the following is considered as a special character by mysql_real_escape_string() ?null byte, single quote, backslash
Which of these has lower memory requirement?mysql_use_result(), mysql_store_result()
How many of the following take a connection handler as argument?mysql_store_result(), mysql_use_result()
The number of attributes in the following table is ______________.CREATE TABLE Student ( Stu_name CHAR(30), Stu_id INT );
To how many of the following does the prepared-statement API apply to?CREATE TABLE, DELETE, DO, INSERT
How many of the following return rows?SELECT, SHOW, DESCRIBE
Which of these is more restrictive?mysql_query(), mysql_real_query()
The default case sensitivity of the database and table names depends on ___________.
Which statement is valid if `sampledb` is a database and `tbl` is a table in it?