Oracle Quiz With Questions & Answers

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Forashish1
F
Forashish1
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,455
| Attempts: 1,457
SettingsSettings
Please wait...
  • 1/7 Questions

    Maximum Number Of Column A Table Can Have In Oracle?

    • 100
    • 500
    • 1000
    • 2000
Please wait...
About This 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.

Oracle Quiz With Questions & Answers - Quiz

Quiz Preview

  • 2. 

    AWR is acronym for 

    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:

  • 3. 

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

    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. 

    Oracle Datapump Introduced In Which Version?

    • Oracle 9i

    • Oracle 10g

    • Oracle 11g

    • Can't say

    Correct Answer
    A. Oracle 10g
  • 5. 

    Which Analytical Function Has Been Added In Oracle 11g?

    • REGEXP_SUBSTR

    • REGEXP_INSTR

    • REGEXP_COUNT

    • REGEXP_LIKE

    Correct Answer
    A. 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:

  • 6. 

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

    • Union

    • Union All

    • Intersect

    • Minus

    Correct Answer
    A. 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. 

    Truncate command has following attributes

    • Redo log generated for truncate

    • Redo log not generated for truncate

    • Lowers HWM

    • No effect on HWM

    Correct Answer(s)
    A. Redo log not generated for truncate
    A. 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:

Quiz Review Timeline (Updated): Mar 22, 2023 +

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.