MySQL Quiz

Which of the following is used to define a table in MySQL?

• DML

• DDL

• DQL

• TCL

Which SQL command is used to modify the structure of an existing table?

• MODIFY

• UPDATE

• ALTER

• CHANGE

Which of the following keywords is used to restrict data modification privileges in MySQL?

• GRANT

• REVOKE

• COMMIT

• ROLLBACK

Which clause is used in SQL to filter results after grouping them?

• HAVING

• WHERE

• ORDER BY

• GROUP BY

Which SQL clause is used to sort results in MySQL?

• ORDER BY

• SORT BY

• GROUP BY

• FILTER BY

What type of join returns all rows from the left table, and matching rows from the right table?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL OUTER JOIN

What does the JOIN operation do in MySQL?

• Combines rows from two or more tables

• Deletes rows from a table

• Modifies data in multiple tables

• Creates new tables

Which aggregate function is used to count the number of rows in MySQL?

• SUM()

• AVG()

• COUNT()

• MAX()

What does the GROUP BY clause do in MySQL?

• Sorts the data

• Filters the data

• Groups rows based on a specific column

• Deletes data from the table

Which SQL command is used to permanently remove a table and all its data from MySQL?

• DROP

• DELETE

• TRUNCATE

• REMOVE