Oracle Quiz With Questions & Answers

7 Questions | By Forashish1 | Last updated: Dec 21, 2018 | Total Attempts: 889

Questions

Settings

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.

Featured Quizzes

Related Topics

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