What jobs Query Optimizer perform in Mysql? – McqOptions

MCQOPTIONS

1.	What jobs Query Optimizer perform in Mysql?
A.	Permissions
B.	Determine the efficient way to execute a query
C.	Syntax errors
D.	All of above
E.	None of these
Answer» C. Syntax errors

Discussion

No Comment Found

Related MCQs

What does name represent in the following code snippet?CREATE TABLE Employee ( Emp_name CHAR(30), Emp_id INT(10), Emp_address CHAR(30), Emp_phone CHAR(12) );
What is true about the following SQL statement?SELECT * FROM Student;
What is the meaning of EMPTY SET in the following query?SELECT First_name, Last_name, Emp_idFROM EmployeeWHERE Last_name= Gupta ;/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec
Which of the following is more efficient?LOAD DATA, INSERT
The function used to convert a string to an int is ______________.
The function used to convert an int to string is ______________.
In MySQL databases, the structure representing the organizational views of the entire databases is ____________.
The MySQL server used in its client/server architecture is _______________.
The tool for copying databases is ______________.
What does name represent in the following code snippet?