MySQL Questions and Answers – Query Clauses

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

1. Which clause is used to determine “which column to include in the query sets”?
a) SELECT
b) FROM
c) WHERE
d) ORDER BY
View Answer

2. Which clause is used to “Identifies table from which to draw table and how the table should be joined”?
a) FROM
b) SELECT
c) ORDER By
d) WHERE
View Answer

3. Which clause is used to “Filters out unwanted data”?
a) FROM
b) WHERE
c) SELECT
d) ORDER BY
View Answer

4. Which clause is used to “group rows together by common columns values”?
a) SELECT
b) GROUP BY
c) FROM
d) WHERE
View Answer

5. Which clause is used to “filter out unwanted Groups”?
a) HAVING
b) FROM
c) WHERE
d) SELECT
View Answer

6. Which clause is used to “sort the rows of the final result set by one or more columns”?
a) HAVING
b) ORDER BY
c) WHERE
d) FROM
View Answer

7. Which clause is used to “Modify the existing field of the table”?
a) ALTER
b) FROM
c) SELECT
d) MODIFY
View Answer

8. Which among the following is not a “query clause”?
a) WHERE
b) MODIFY
c) ALTER
d) FROM
View Answer

9. “MODIFY” is used with which “Query clause”?
a) ALTER
b) FROM
c) WHERE
d) ORDER BY
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.