Problem 2.3: Update the EMP table to set the commission of all employees to Rs 1000/- who are working as MANAGERS. Problem 2.4: Create a pseudo table EMPLOYEE with the same structure and records as...

Problem 2.3: Update the EMP table to set the commission of all employees to

Rs 1000/- who are working as MANAGERS.
Problem 2.4: Create a pseudo table EMPLOYEE with the same structure and

records as the table EMP using select clauses.
Problem 2.5: Delete only those who are working as supervisors.
Problem 2.6: Delete the rows whose EMPNO is 12.
Problem 2.7: List the records in the EMP table ORDERBY SALARY in ascending

order.
Problem 2.8: List the records in the EMP table ORDERBY salary in Descending

order.
Problem 2.9: Display only those employees whose DEPTNO is 11.
Problem 2.10: Display department mummers in EMP table avoiding the

duplicated values.
Problem 2.11: List the records in sorted order of their employees.
Problem 2.12: Create a MANAGER table from the EMP table which should

hold details only about the managers.
Problem 2.13: List the employee names whose SALARY is null.
Problem 2.14: List the EMPLOYEE NAMES and the DEPARTMENT NAME in which

they are working

Extracted text: there will be extreme consequences. Questions: Problem 2.1: INSERT S RECORDS INTO DEPT TABLE. DEPTNO DNAME LOC 11 IT ABHA 12 ACCOUNTS JAZAN 13 HR ABHA 14 TESTING ABHA 15 ADMIN JAZAN Problem 2.2: Insert 5 records into EMP table s simultaneously using INSERT ALL. ЕMPNO ENAME JOB SALARY DEPTNO 1001 MAX CLERK 4000 15 1002 ROHAN ARCHITECT 8500 11 1003 HUSSIAN MANAGER 16000 11 1004 PROGRAMMER 9000 11 1005 AISHA HR 9000 13 1006 AHMAD MANAGER 12 Problem 2.3: Update the EMP table to set the commission of all employees to Rs 1000/- who are working as MANAGERS. Problem 2.4: Create a pseudo table EMPLOYEE with the same structure and records as the table EMP using select clauses. Problem 2.5: Delete only those who are working as supervisors. Problem 2.6: Delete the rows whose EMPNO is 12. Problem 2.7: List the records in the EMP table ORDERBY SALARY in ascending