Oracle Quiz With Questions & Answers

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Forashish1

Forashish1

Community Contributor

Quizzes Created: 1 | Total Attempts: 1,439

Questions: 7 | Attempts: 1,439 | Updated: Mar 22, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

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
Correct Answer
C. REGEXP_COUNT

Explanation
In Oracle 11g, the REGEXP_COUNT function has been added. This function is used to count the number of occurrences of a pattern in a string. It takes two arguments - the string to be searched and the regular expression pattern to be matched. The function returns the number of times the pattern is found in the string.

Rate this question:

1
0
2.

Maximum Number Of Column A Table Can Have In Oracle?
- A.
  
  100
- B.
  
  500
- C.
  
  1000
- D.
  
  2000
Correct Answer
C. 1000

Explanation
In Oracle, the maximum number of columns a table can have is 1000. This means that a table can have up to 1000 different columns to store data. Having a high limit like this allows for more flexibility and complexity in database design, as it can accommodate a wide range of data types and attributes. It is important to note that having a large number of columns in a table can impact performance and efficiency, so it is recommended to carefully consider the design and organization of data when approaching this limit.

Rate this question:

1
0
3.

Oracle Datapump Introduced In Which Version?
- A.
  
  Oracle 9i
- B.
  
  Oracle 10g
- C.
  
  Oracle 11g
- D.
  
  Can't say
Correct Answer
B. Oracle 10g
4.

You are using command prompt to access Oracle db. If you want to switch to DOS prompt, then you will type?

Correct Answer
host
Host

Explanation
To switch to the DOS prompt while using command prompt to access Oracle db, the correct command to be typed is "host" or "Host". This command allows the user to temporarily exit from the command prompt and access the DOS prompt.

Rate this question:

4
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
Correct Answer(s)
B. Redo log not generated for truncate
C. Lowers HWM

Explanation
The correct answer is "Redo log not generated for truncate, Lowers HWM." When the truncate command is used, it does not generate a redo log. This means that the changes made by the truncate command are not recorded in the redo log, which can be useful for performance reasons. Additionally, the truncate command lowers the high water mark (HWM) of a table. The HWM represents the maximum amount of space that has been allocated to a table, and by lowering it, the truncate command frees up space in the table for future use.

Rate this question:
6.

Which set operator can be used to join two sub-queries ?
- A.
  
  Union
- B.
  
  Union All
- C.
  
  Intersect
- D.
  
  Minus
Correct Answer
C. Intersect

Explanation
The Intersect set operator can be used to join two sub-queries. It returns the common rows between the two sub-queries, eliminating any duplicate rows. This operator is useful when you want to find the intersection of two result sets, i.e., the rows that are present in both sub-queries.

Rate this question:
7.

AWR is acronym for

Correct Answer
Automated Workload Repository
automated workload repository
Automatic Workload Repository
automatic workload repository

Explanation
AWR stands for Automated Workload Repository. It is a built-in feature of Oracle Database that collects and stores performance statistics of the database. AWR provides a historical perspective of the database workload and can be used for performance tuning and troubleshooting. The repository stores data such as SQL statements, wait events, system statistics, and other performance-related information. By analyzing the data in AWR, database administrators can identify performance bottlenecks, diagnose issues, and make informed decisions to optimize the database performance.

Rate this question:

4

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 22, 2023

Quiz Edited by
ProProfs Editorial Team
Dec 06, 2012

Quiz Created by
Forashish1

Oracle Quiz With Questions & Answers

Which Analytical Function Has Been Added In Oracle 11g?

Maximum Number Of Column A Table Can Have In Oracle?

Oracle Datapump Introduced In Which Version?

You are using command prompt to access Oracle db. If you want to switch to DOS prompt, then you will type?

Truncate command has following attributes

Which set operator can be used to join two sub-queries ?

AWR is acronym for