oracle dba interview questions and answers Interview Questions and Answers

  • SAP BASIS Interview Questions and answers for Freshers

    Question.1  How to create user account? Answer: Using T_code SUO1 we create the user accounts. Question.2   what are the various steps for crating the User? Answer: Address Data, Logon Data, Defaults, Parameters, Profiles, Activity groups, Users. [sociallocker]           Question.3 What are the Different types of users?..

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

  • SAP BASIS Interview Questions and Answers

    Question.1 What is private mode? When does user switch to user mode? Answer: Private mode is a mode where the heap data is getting exclusively allocated by the user and is no more shared across the system. This happens when your extended memory is exhausted. Question.2 What is osp$ mean?..

  • MSBI Interview Questions and Answers

    Question.1 What is Query parameter in SSRS? Answer: Query parameters is mentioned in the query of the datasources that are to be included into the SQL script’s WHERE clause of the SQL that can accept parameters. Query parameters begin with the symbol @.The name should not contain spaces and can..

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