Question

Describe about any two DML commands of SQL.

Hint:

DML commands help modify the data stored in a database, ensuring the records are up-to-date and accurate.

Answer 1

Step 1: Define DML Commands.
DML (Data Manipulation Language) commands are used to manipulate and manage data in relational databases. These commands allow users to insert, update, and delete data from tables.
Step 2: Explain the DML commands.
(1) INSERT:
The INSERT command is used to add new rows of data to a table. For example: \[ \text{INSERT INTO students (id, name, age) VALUES (1, 'John', 20);} \] (2) UPDATE:
The UPDATE command is used to modify existing data in a table. For example: \[ \text{UPDATE students SET age = 21 WHERE id = 1;} \]