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

  • Oracle Interview Questions and answers

    Question.1   What is a database? Answer:    Database offer a single point of mechanism for storing and retrieving information with the help of tables. Table is made up of columns and rows where each column stores specific attribute and each row displays a value for the corresponding attribute.  It is a..

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

Quick Enquiry
We respond as soon as possible.
2016 (C) All rights reserved.
Submit your details
2017 (C) All rights reserved.