Oracle DBA Interview Questions and Answers

  • Oracle Interview Questions and answers with examples 3

    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…



  • Oracle Interview Questions and answers with examples 2

    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; [sociallocker] Question.22       To  display  the  maximum  salary  of  employee  working  as  a   salesman. Answer:                SQL>SELECT MAX(sal) FROM..



  • Oracle Interview Questions and answers with examples

    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 02-Apr-95 2975 20 7654 MARIA SALESMAN 7698 28-Sep-95 1250 1400 30 7698 BILL..



  • Oracle DBA Interview Questions and answers

    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..