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
Explanation: None.
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
Explanation: None.
3. Which clause is used to “Filters out unwanted data”?
a) FROM
b) WHERE
c) SELECT
d) ORDER BY
View Answer
Explanation: None.
4. Which clause is used to “group rows together by common columns values”?
a) SELECT
b) GROUP BY
c) FROM
d) WHERE
View Answer
Explanation: None.
5. Which clause is used to “filter out unwanted Groups”?
a) HAVING
b) FROM
c) WHERE
d) SELECT
View Answer
Explanation: None.
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
Explanation: None.
7. Which clause is used to “Modify the existing field of the table”?
a) ALTER
b) FROM
c) SELECT
d) MODIFY
View Answer
Explanation: None.
8. Which among the following is not a “query clause”?
a) WHERE
b) MODIFY
c) ALTER
d) FROM
View Answer
Explanation: Modify is not a clause, it just used with clause Alter.
9. “MODIFY” is used with which “Query clause”?
a) ALTER
b) FROM
c) WHERE
d) ORDER BY
View Answer
Explanation: Modify is not a clause, it just used with clause Alter.
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.
- Apply for Programming Internship
- Check Information Technology Books
- Check MySQL Books
- Practice Programming MCQs