Question

Write the syntax and use of SQL DDL commands (CREATE, ALTER, DROP) and DML commands (INSERT, UPDATE, DELETE).

Hint:

• {DDL} – Defines structure of database (CREATE, ALTER, DROP).
• {DML} – Manipulates data inside tables (INSERT, UPDATE, DELETE).

In short: \[ \text{DDL → Structure of tables} \quad | \quad \text{DML → Data inside tables} \]

Answer 1