Oracle Quiz With Questions & Answers

7 Questions

Settings
Please wait...
Oracle Quizzes & Trivia

Here you will find questions related to Oracle db, SQL, PL/SQL. Questions are not in specific order and their is no time limit to complete this quiz.


Questions and Answers
  • 1. 
    Which Analytical Function Has Been Added In Oracle 11g?
    • A. 

      REGEXP_SUBSTR

    • B. 

      REGEXP_INSTR

    • C. 

      REGEXP_COUNT

    • D. 

      REGEXP_LIKE

  • 2. 
    Maximum Number Of Column A Table Can Have In Oracle?
    • A. 

      100

    • B. 

      500

    • C. 

      1000

    • D. 

      2000

  • 3. 
    Oracle Datapump Introduced In Which Version?
    • A. 

      Oracle 9i

    • B. 

      Oracle 10g

    • C. 

      Oracle 11g

    • D. 

      Can't say

  • 4. 
    You are using command prompt to access Oracle db. If you want to switch to DOS prompt, then you will type?
  • 5. 
    Truncate command has following attributes
    • A. 

      Redo log generated for truncate

    • B. 

      Redo log not generated for truncate

    • C. 

      Lowers HWM

    • D. 

      No effect on HWM

  • 6. 
    Which set operator can be used to join two sub-queries ?
    • A. 

      Union

    • B. 

      Union All

    • C. 

      Intersect

    • D. 

      Minus

  • 7. 
    AWR is acronym for