Question

Q1) Short Answer Type questions:
1) Differentiate between DDL & DML commands.
Dron Command.​

Answer 1

Answer:

1) DDL: It stands for Data Definition Language.

  DML: It stands for Data Manipulation Language.

2) DDL: It is used to create database schema and can be used to define    some   constraints as well.

   DML: It is used to add, retrieve or update the data.

3) DDL: It basically defines the column (Attributes) of the table.

   DML: It add or update the row of the table. These rows are called as tuple.

4) DDL: It doesn’t have any further classification.

   DML: It is further classified into Procedural and Non-Procedural DML.

5) DDL: Basic command present in DDL are CREATE, DROP, RENAME, ALTER etc.

   DML: BASIC command present in DML are UPDATE, INSERT, MERGE etc.

6) DDL: DDL does not use WHERE clause in its statement.

   DML: While DML uses WHERE clause in its statement.

HOPE IT HELPS YOU....