1.

What is the difference between DDL and DML

Answer» DDL\t:-It stands for Data Definition Language.\tDML :- It stands for Data Manipulation Language.DDL:-It is used to create database schema and can be used to define some constraints as well.DML:-\tIt is used to add, retrieve or update the data.It basically defines the column (Attributes) of the table.DDL:-\tIt add or update the row of the table. These rows are called as tuple.DDL:-It doesn’t have any further classification.DML:-It is further classified into procedural and Non-Procedural DML.DDL:-Basic command present in DDL are CREATE, DROP, RENAME, ALTER etc.DML:-\tBASIC command present in DML are UPDATE, INSERT, MERGE etc.


Discussion

No Comment Found