Question

Differentiate between DDL and DML commands.
Write syntax of all the commands for DDL and DML
NO SPAM​

Answer 1

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

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

Language                                          command list

DDL-CREATE DROP ALTER RENAME TRUNCATE

DML-SELECT INSERT UPDATE DELETE

DCL-GRANT REVOKE

TCL-START TRANSACTION COMMIT ROLLBACK

Explanation: