The log that identifies statements that may be in need of being rewrit – McqOptions

MCQOPTIONS

1.	The log that identifies statements that may be in need of being rewritten for better performance is ______________.
A.	binary log
B.	slow query log
C.	general query
D.	error log
E.	None of these
Answer» C. general query

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>