DATA MANIPULATION LANGUAGE (DML) COMMANDS

Insert a record into STUDENT table with values:

SID = 101, SNAME = 'RAHUL', AGE = 20, COURSE = 'MCA'.

Insert a record into EMPLOYEE table with

EID = 201, ENAME = 'ANITA', SALARY = 45000, DEPTNO = 10.

Insert a new department into DEPT table; DEPTNO = 50, DNAME = 'TRAINING', LOC = 'DELHI'

Insert a record into BOOK table with only BOOK_ID, TITLE, and PRICE.

Insert multiple rows into COURSE table.

Insert data into EMP_COPY table from the EMP table.

Insert employees from EMP whose salary is greater than 3000 into EMP_HIGH_SAL.

Insert employees hired after 1981 into EMP_NEW_HIRE.

Insert department numbers and names from DEPT into a table called DEPT_BACKUP.

Insert employee names and salaries into a table EMP_SALARY_RECORD.

Update the salary of employee SMITH to 2000.

Increase salary of all employees by 10%.

Update the department number of employee ALLEN to 20.

Update commission of SALESMAN to 500.

Update job of employee MILLER to MANAGER.

Increase salary of employees in department 10 by 20%.

Update salary of employees whose job is CLERK to 1500.

Update location of department 30 to MUMBAI.

Update commission of employees who have NULL commission to 100.

Update salary of employees who earn less than average salary.

Delete employee SMITH from EMP table.

Delete all employees working in department 30.

Delete employees whose salary is less than 1000.

Delete employees hired before 1981.

Delete employees who do not receive commission.

Delete departments located in CHICAGO.

Delete employees whose job is CLERK.

Delete employees earning the minimum salary.

Delete employees working in departments located in NEW YORK.

Delete employees whose manager number is NULL.