The SQL Data Manipulation Language (DML) includes a Query language bas

1.	The SQL Data Manipulation Language (DML) includes a Query language based on relational algebra.(a) Give any four commands used in DML. (b) Write an SQL statement to INSERT values to the elds (adm_no, name, course, percent) with values (101, “Anoop”, “Science”, 75) for the table STUD.
Answer» (a) Insert, delete, select and update (b) insert into STUD values(101,’Anoop’,’Science’,75);

The SQL Data Manipulation Language (DML) includes a Query language based on relational algebra.(a) Give any four commands used in DML. (b) Write an SQL statement to INSERT values to the elds (adm_no, name, course, percent) with values (101, “Anoop”, “Science”, 75) for the table STUD.

Answer»

(a) Insert, delete, select and update

(b) insert into STUD

values(101,’Anoop’,’Science’,75);