Database - Introduction to SQL - Discussion

DLL, because is a only a data definition language.

DDL:

Data Definition Language (DDL) statements are used to define the database structure or schema. examples:

CREATE - to create objects in the database.
ALTER - alters the structure of the database.

DML:

Data Manipulation Language (DML) statements are used for managing data within schema objects. Some examples:

SELECT - retrieve data from the a database.
INSERT - insert data into a table.
UPDATE - updates existing data within a table.

DCL:

Data Control Language (DCL) statements

TCL:

Transaction Control (TCL) statements are used to manage the changes made by DML statements. It allows statements to be grouped together into logical transactions.

Then please tell me what is DML?

Mean of DDL is Data Definition language. It is the category of sql.

DDL means Data Definition language & it is used for creating, inserting, deleting the table. And alter is used for altering the table.

The SQL ALTER TABLE statement allows you to rename an existing table. It can also be used to add, modify, or drop a column from an existing table.

What is alter?

Indeed SQL is both DML and DDL
but the question is asking SQL data DEFINITION commands
So the answer is A) DDL (data DEFINITION language)

What is the full name of DDL ?

SQL is both DML and DDL language.
ex for DDL:- CREATE,DROP,ALTER
ex for DML:-SELECT FROM WHERE...