MySQL Quiz: DDL, DML, and SELECT

Which of the following is a DDL command?

• CREATE

• INSERT

• UPDATE

• DROP

Which SQL clause is used to filter records based on a specific condition?

• SELECT

• FROM

• WHERE

• ORDER BY

What does the DELETE statement do?

• Removes all data

• Removes data only

• Removes structure

• None of the above

The command to modify the structure of a table is:

• CREATE

• DROP

• ALTER

• INSERT

Which of these is not a DML command?

• INSERT

• UPDATE

• DELETE

• DROP

What keyword is used to remove duplicate values in a SELECT query?

• DISTINCT

• UNIQUE

• FILTER

• GROUP BY

The command ______ TABLE table_name; is used to delete a table from the database.

To insert a record into a table, we use the ______ command.

The clause ______ BY is used to sort data in ascending or descending order.

______ clause is used with SELECT to group rows that have the same values in specified columns.