Question

Differentiate between DDL & DML commands. Identify DDL & DML commands from the following:-

(UPDATE, SELECT, ALTER, DROP)

Answer 1

DDL stands for Data Definition language and comprises of commands which will change the structure of database object.

DML stands for Data Manipulation Language and comprises of commands which are used to insert, edit, view & delete the data stored in a database object.

DDL Commands: ALTER, DROP

DML Commands: UPDATE, SELECT