Question

Differentiate

DDL and DML commands With
example.​

Answer 1

Answer:

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.

These SQL commands are mainly categorized into four categories as: DDL – Data Definition Language. DQl – Data Query Language.

Examples of DML:

INSERT – is used to insert data into a table.

UPDATE – is used to update existing data within a table.

DELETE – is used to delete records from a database table.

Answer 2

Answer:

Ddl:

As the name suggest it defines the language.

Eg. Alter, create, drop

Dml:

As the name suggests it manipulate the data.

Eg. Insert, update,