Recall & Review
beginner
What does DDL stand for in SQL?
DDL stands for Data Definition Language. It includes commands that define or change database structures, like creating or dropping tables.
Click to reveal answer
beginner
Name three common DML commands.
Common DML commands are INSERT (to add data), UPDATE (to change data), and DELETE (to remove data).
Click to reveal answer
beginner
What is the purpose of DQL in SQL?
DQL stands for Data Query Language. It is used to retrieve data from the database, mainly using the SELECT statement.
Click to reveal answer
intermediate
What does DCL control in SQL?
DCL stands for Data Control Language. It controls access to data by managing permissions with commands like GRANT and REVOKE.
Click to reveal answer
intermediate
Match the SQL statement category to its example: CREATE TABLE, SELECT, INSERT, GRANT.
CREATE TABLE is DDL, SELECT is DQL, INSERT is DML, and GRANT is DCL.
Click to reveal answer
Which SQL category includes the SELECT statement?
✗ Incorrect
SELECT is used to query data, so it belongs to Data Query Language (DQL).
Which command is NOT part of DML?
✗ Incorrect
CREATE is a DDL command used to define database structures, not to manipulate data.
What does the GRANT command do?
✗ Incorrect
GRANT is a DCL command that gives permissions to users.
Which category would DROP TABLE belong to?
✗ Incorrect
DROP TABLE changes the database structure, so it is a DDL command.
Which SQL category is mainly about changing data inside tables?
✗ Incorrect
DML commands like INSERT, UPDATE, and DELETE change the data inside tables.
Explain the four main SQL statement categories and give one example command for each.
Think about what each category does: structure, data, query, or permissions.
You got /4 concepts.
Why is it important to know the difference between DDL, DML, DQL, and DCL when working with databases?
Consider how different commands affect the database and user access.
You got /4 concepts.