Question.40 Display the name,job of the employees and display Executive if the job is Clerk , RM if the job is Manager else display the job. Answer: SELECT ename,job, DECODE(job, ‘CLERK’, ‘EXECUTIVE’, ‘MANAGER’, ‘RM’, job) FROM emp; Question.41 To display employee name, department name and department number for all employees…
Question. 20 To display the number of employees working with the company. Answer: SQL>SELECT COUNT(*) FROM emp; Question.21 To display the total salaries payable to employees. Answer: SQL>SELECT SUM(sal) FROM emp; Get A live Demo Oracle Online Course
Emp Table: EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO 7369 SMITH CLERK 7902 17-Dec-95 800 20 7499 ASHA SALESMAN 7698 20-Feb-95 1600 300 30 7521 WASIM SALESMAN 7698 22-Feb-95 1250 500 30 7566 RAJA MANAGER 7839 2-Apr-95 2975 20 7654 MARIA SALESMAN 7698 28-Sep-95 1250 1400 30 7698 BILL..
Question.1 What is Consistent Backup? Answer: A Consistent backup is one in which the files being backed up contain all changes upto the same system change number (SCN). Question.2 What is fractured Block? Answer: Because the database continues writing to the file during an online backup, there is the possibility..