Oracle Quiz With Questions & Answers
7 Questions
| Total Attempts: 1101
(210).jpg "Oracle Quiz With Questions & Answers")
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
PL/SQL is a procedural language extension to Structured Query Language. You can take this Oracle PL/SQL quiz questions and answers and check your knowledge. The purpose of PL/SQL is to combine database language and procedural...
Questions: 30 | Attempts: 12505 | Last updated: Nov 18, 2021
-
Sample QuestionSelect incorrect variable declarations
Are you able to pass this Oracle PL/SQL test? This free procedural language is designed to run alongside the SQL within the same server process, bringing optimal efficiency. The Oracle PL, although not portable and doesn't...
Questions: 45 | Attempts: 3082 | Last updated: Sep 23, 2020
-
Sample QuestionSelect incorrect variable declarations
Questions: 40 | Attempts: 3165 | Last updated: Feb 4, 2013
-
Sample QuestionYou attempt to query the data base with this command: SELECT name,salary FROM employee WHERE salary= (SELECT salary FROM employee WHERE last_name= ‘Wagner’ OR dept_no=233) Why could this statement cause an error?
Back to top