MySQL Questions and Answers – Query Mechanics

This set of MySQL Multiple Choice Questions & Answers (MCQs) focuses on “Query Mechanics”.

1. Which compiler is used to execute the structured query language?
a) DCL
b) DDL
c) DML
d) None of the mentioned
View Answer

2. Which among the following tags belong to Data definition language?
a) SELECT
b) FROM
c) WHERE
d) All of the mentioned
View Answer

3. Which among the following tags belong to Data Manipulation language?
a) UPDATE
b) ALTER
c) MODIFY
d) All of the mentioned
View Answer

4. Query Mechanism performs the following functions?
a) Syntax correction
b) Checking permission for executing the query
c) Checking permission for accessing the desired data
d) All of the mentioned
View Answer

5. What jobs “Query Optimizer” perform in Mysql?
a) Determine the efficient way to execute a query
b) Syntax errors
c) Permissions
d) All of the mentioned
View Answer

6. What is the meaning of “EMPTY SET” in the following MySQL command?

SELECT fname, lname, person_id
FROM person
WHERE lname=’s’;
/* after Execution*/ Mysql tool RETURN EMPTY SET 0:00sec

a) No values
b) Error
c) Access denied
d) None of the mentioned
View Answer

7. Which are the two languages used in Mysql?
a) DML/DDL
b) DDL/DCL
c) DML/DDM
d) None of the mentioned
View Answer

8. The users responsible for query processing in database system are ___________
a) Native users
b) Application programmers
c) Sophisticated users
d) Specialized users
View Answer

9. Select the sequence for how the query mechanism works?
a) Authentication-> DDL->DML->query optimizer->output
b) DDL->DML->query optimizer-> Authentication->output
c) DML->query optimizer-> Authentication-> DDL-> output
d) All of the mentioned
View Answer

Sanfoundry Global Education & Learning Series – MySQL Database.

To practice all areas of MySQL Database, here is complete set of 1000+ Multiple Choice Questions and Answers.