Write the differences between DDL and DML commands with any two examples each.

Question

Accepted Answer

DDL (Data Definition Language) commands define and manage the structure of the database, such as tables and columns, without affecting the actual data. Examples: CREATE TABLE Student (...); and ALTER TABLE Student ADD Grade VARCHAR(10); DML (Data Manipulation Language) commands manage the data inside the tables, such as adding, updating, or deleting records, without changing the table structure. Examples: INSERT INTO Student VALUES (1,'Ram',18,'Kathmandu'); and UPDATE Student SET Age=19 WHERE ID=1;