Oracle Quiz With Questions & Answers

7 Questions | Attempts: 1366
SettingsSettingsSettings
Please wait...
Create your own Quiz
Oracle Quiz With Questions & Answers - Quiz

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 

Related Topics

Recent Quizzes

Oracle SQL Fundamentals Quiz! Test Oracle SQL Fundamentals Quiz! Test
A Quiz About Oracle Application Express A Quiz About Oracle Application Express
Oracle Performance Tuning Trivia Quiz! Oracle Performance Tuning Trivia Quiz!
Oracle Data Integrator Test Quiz! Trivia Oracle Data Integrator Test Quiz! Trivia
Can you pass the OBIEE Test? Quiz! Can you pass the OBIEE Test? Quiz!
What Do You Know About Oracle Flexcube? What Do You Know About Oracle Flexcube?
What Do You Know About Oracle Application Integration Architecture? What Do You Know About Oracle Application Integration Architecture?
What Do You Know About Oracle API Gateway? What Do You Know About Oracle API Gateway?
What Do You Know About Oracle Business Activity Monitoring? What Do You Know About Oracle Business Activity Monitoring?

Featured Quizzes

Maths Quiz For Grade 6 With Answers Maths Quiz For Grade 6 With Answers
Guess The Asian Test Quiz Guess The Asian Test Quiz
Which Premier League Team Should I Support? Quiz Which Premier League Team Should I Support? Quiz
What Should I Be When I Grow Up Quiz What Should I Be When I Grow Up Quiz
Which emotion best describes you? Which emotion best describes you?
Are You Smarter Than A 5th Grader? Quiz Questions Are You Smarter Than A 5th Grader? Quiz Questions

Popular Topics

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.