Question

Differentiate Between DDL And DML Commands With Example.

Answer 1

The difference between DDL and DML are:

DDL-Data Definition Language	DML-Data Manipulation Language
It is declarative	It is imperative
DDL is used to define data structures	DML is used to manipulate data
DDL defines the column of the table	DML adds or updates the row of the table
DDL is not further classified	DML is further classified into Procedural DML Non-Procedural DML
DDL does not use the WHERE clause in its statement	DML uses the WHERE clause in its statements
DDL commands examples are CREATE ALTER DROP	DML commands examples are INSERT UPDATE DELETE