Question

Categorise the following commands as DDL and DML:
select, alter, insert, drop

Answer 1

${\bold{\huge{\red{\underline{\green{ANSWER}}}}}}$

DDL:

DDL is Data Definition Language which is used to define data structures. For example: create table, alter table are instructions in SQL.

DML:

DML is Data Manipulation Language which is used to manipulate data itself. For example: insert, update, delete are instructions in SQL.

Answer 2

Answer:

Select and Insert commands will fall under DML. Alter and Drop commands will fall under DDL.

Explanation:

What are DDL commands?

Users, databases, schemas, tables, views, columns, functions, and stored procedures are all created, manipulated, and modified in Snowflake using Data Definition Language (DDL) commands.

What are DML commands?

In SQL, the Data Manipulation Language (DML) commands are used to manipulate data records contained in database tables. It is unaffected by changes to the database's objects and structure. INSERT, UPDATE, and DELETE are the most regularly used DML commands.

Thus, the DDL command creates the database schema, while the DML command populates and manipulates the database.