MYSQL MCQ and Answers – Part 6

MYSQL MCQs questions with answers to prepare for exams, tests, and certifications. These questions are taken from a real written exam and some parts are taken from an interview. So you will find questions on MySQL Database, SQL query, Data Model, and more. This MCQ will easily prepare anyone to pass their exam.
 

1. Which clause is used to determine which column to include in the query sets?

A SELECT

B FROM

C WHERE

D ORDER BY

Answer  

2. Which clause is used to identify the table?

A SELECT

B FROM

C WHERE

D ORDER BY

Answer  

3. Which clause is used to filter the data?

A SELECT

B FROM

C WHERE

D ORDER BY

Answer [st_adsense]  

4. Which clause is used to group rows by common column values?

A SELECT

B GROUP BY

C ORDER BY

D WHERE

Answer  

5. Which clause is used to filter groups?

A HAVING

B FROM

C WHERE

D SELECT

Answer  

6. Which clause is used to sort the result by one or more columns?

A HAVING

B FROM

C ORDER BY

D WHERE

Answer  

7. The keyword “MODIFY” is used with which query clause?

A ALTER

B FROM

C WHERE

D ORDER BY

Answer [st_adsense]  

8. Which of the following is not a query clause?

A WHERE

B MODIFY

C ALTER

D FROM

Answer  

9. Which clause is used to modify the existing field of the table?

A ALTER

B FROM

C SELECT

D MODIFY

Answer  

10. What statement is used to show the definition of an existing database?

A SHOW CREATE DATABASE

B SHOW DATABASE

C SHOW CREATE

D SHOW CREATE DATABASE TABLE

Answer