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?<br>functions, procedures, triggers, events
How many of the following is considered as a special character by mysql_real_escape_string() ?<br>null byte, single quote, backslash
Which of these has lower memory requirement?<br><pre class="prettyprint lang-c">mysql_use_result(), mysql_store_result()<br></pre>
How many of the following take a connection handler as argument?<br><pre class="prettyprint lang-c">mysql_store_result(), mysql_use_result()<br></pre>
The number of attributes in the following table is ______________.<br><pre class="prettyprint lang-c">CREATE TABLE Student (<br> Stu_name CHAR(30),<br> Stu_id INT<br> );<br></pre>
To how many of the following does the prepared-statement API apply to?<br>CREATE TABLE, DELETE, DO, INSERT
How many of the following return rows?<br>SELECT, SHOW, DESCRIBE
Which of these is more restrictive?<br><pre class="prettyprint lang-c">mysql_query(), mysql_real_query()<br></pre>
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?