The statement that performs key distribution analysis and stores the d – McqOptions

MCQOPTIONS

1.	The statement that performs key distribution analysis and stores the distribution for the named tables is _____________.
A.	ANALYZE TABLE
B.	CHECKSUM TABLE
C.	OPTIMIZE TABLE
D.	CHECK TABLE
E.	None of these
Answer» B. CHECKSUM TABLE

Discussion

No Comment Found

Related MCQs

Which of these is not optional?<br><pre class="prettyprint lang-c">SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns;<br></pre>
How many of these are for use with only MyISAM tables?<br>mysql, mysqladmin, mysqldump, mysqlisamchk
How many of these can replace level in myisam-recover = level ?<br>BACKUP, FORCE, QUICK
REPAIR TABLE works with how many of the following?<br>MyISAM, ARCHIVE, CSV
The higher priority is ______________.<br>writes, reads
With only MyISAM tables, how many of the following are for use?<br>mysql, mysqladmin, mysqldump, mysqlisamchk
How many of the following languages can interface to bind to the C API of MySQL?<br>Perl, PHP, Python
CHECK TABLE works with how many of the following?<br>MyISAM, ARCHIVE, CSV
What is the table name in the following?<br><pre class="prettyprint lang-c">INSERT INTO Employee VALUES('Rahul','M',NULL);<br></pre>
What is InnoDB in the following code?<br><pre class="prettyprint lang-c">CREATE TABLE Employee (<br> Emp_name CHAR(30),<br> Emp_id INT,<br> PRIMARY KEY (Emp_id)<br> ) ENGINE = InnoDB;<br></pre>