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
F
Forashish1
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,435
Questions: 7 | Attempts: 1,436

SettingsSettingsSettings
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:

  • 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:

  • 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:

  • 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:

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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.