To perform analysis of key values by the server, the statement used is – McqOptions

MCQOPTIONS

1.	To perform analysis of key values by the server, the statement used is __________.
A.	PERFORM ANALYSIS
B.	ANALYZE KEYS
C.	PERFORM TABLE ANALYSIS
D.	ANALYZE TABLE
E.	None of these
Answer» E. None of these

Discussion

No Comment Found

Related MCQs

Which of the following WHERE clauses is faster?<br><pre class="prettyprint lang-c">1. WHERE col * 3 < 9<br>2. WHERE col < 9 / 3<br></pre>
What are the results of the following queries if col is an integer column?<br><pre class="prettyprint lang-c">1. SELECT * FROM student WHERE id = '6';<br>2. SELECT * FROM student WHERE id = 6;<br></pre>
Find the error<br><pre class="prettyprint lang-c">CREATE TABLE Employee<br> (Employee_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATE<br> CONSTRAINTS pk_Employee PRIMARY KEY (Employee_id));<br> INSERT INTO Employee<br> VALUES(Employee_id, name, LAST, Birth_date)<br> (1, s , p , 24-1991-01);<br></pre>
Find the error?<br><pre class="prettyprint lang-c">CREATE TABLE Employee<br>( Employee_id SMALLINT, name VARCHAR, LAST VARCHAR<br> CONSTRAINTS pk_Employee PRIMARY KEY (Employee_id));<br> INSERT INTO Employee<br> VALUES( Employee_id, name, LAST)<br> (1, s , p );<br> INSERT INTO person<br> ( Employee_id, name, LAST)<br> VALUES(1, s , p );<br></pre>
Find the error
Which of the following are the valid database datatypes in Mysql?
To perform analysis of key values by the server, the statement used is __________.
What are the results of the following queries if col is an integer column?
Which of the following WHERE clauses is faster?