Recall & Review
beginner
What does DDL stand for in databases?
DDL stands for Data Definition Language. It is used to define and manage database structures like tables and schemas.
Click to reveal answer
beginner
What is the purpose of the CREATE command in DDL?
The CREATE command is used to make new database objects such as tables, indexes, or views.
Click to reveal answer
intermediate
How does the ALTER command work in DDL?
ALTER changes the structure of an existing database object, like adding a new column to a table or changing a column's data type.
Click to reveal answer
beginner
What happens when you use the DROP command?
DROP deletes a database object completely, such as a table or index, removing all its data and structure.
Click to reveal answer
intermediate
Can you recover data after using DROP on a table?
Usually, no. DROP removes the table and its data permanently unless you have backups or special recovery tools.
Click to reveal answer
Which DDL command is used to create a new table?
✗ Incorrect
CREATE is the command used to make new tables or other database objects.
What does the ALTER command do?
✗ Incorrect
ALTER modifies the structure of an existing table, like adding or changing columns.
Which command removes a table and all its data permanently?
✗ Incorrect
DROP deletes the table and its data completely.
If you want to add a new column to an existing table, which command should you use?
✗ Incorrect
ALTER lets you add new columns or change existing ones in a table.
Which of these is NOT a DDL command?
✗ Incorrect
INSERT is a DML command used to add data, not to define database structure.
Explain the roles of CREATE, ALTER, and DROP commands in managing database structures.
Think about how you build, change, or remove things in real life.
You got /3 concepts.
Describe what happens when you use the DROP command on a table and why it should be used carefully.
Consider deleting a file on your computer.
You got /3 concepts.