INTERVIEW QUESTIONS: DATA MANIPULATION LANGUAGE (DML) COMMANDS

Delete employees earning less than the average salary.

Delete employees whose department is located in NEW YORK.

Delete employees working in departments with less than 3 employees.

Delete employees who earn less than all MANAGERS.

Delete employees whose salary equals the minimum salary of their department.

Increase salary by 15% for employees earning less than department average.

Delete employees who are not managers but earn more than at least one manager.

Insert employees with highest salary from each department into TOP_EMP table.

Update commission to 10% of salary for SALESMAN.

Delete employees who earn the second highest salary in the company.

Insert employees earning more than 3000 into EMP_HIGH_SAL table.

Insert employees working in department 20 into EMP_DEPT20 table.

Insert employee name and salary into EMP_SAL_REPORT from EMP table.

Insert employees whose job is MANAGER into EMP_MANAGER table.

Insert employees hired after 1982 into EMP_RECENT table.

Increase salary of employees who work in department 20.

Update salary of employees to match the average salary of their department.

Update salary of employees earning less than department average.

Update department number of employees working in DALLAS.

Update salary of employees who earn less than manager salary.