OCA - Oracle Database Administration Test Quiz

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 Danial98
D
Danial98
Community Contributor
Quizzes Created: 2 | Total Attempts: 8,429
Questions: 6 | Attempts: 6,185

SettingsSettingsSettings
OCA - Oracle Database Administration Test Quiz - Quiz

Description: This online OCA Oracle database administration quiz is aim to test your knowledge on 11g administration and help you prepare for OCA certification.


Questions and Answers
  • 1. 

    Which of these languages can run within the database ? (choose all correct answers).

    • A.

      C.

    • B.

      Java

    • C.

      PL/SQL

    • D.

      SQL

    • E.

      Any other language, if it is linked with OCI libararies.

    Correct Answer(s)
    B. Java
    C. PL/SQL
    D. SQL
    Explanation
    B,C, and D. SQL, PL/SQL and Java are implemented internally to the database. A is wrong because C is not available internally (though with OCI, it can of course be used for writing user processes). E is wrong because OCI is used for writing user processes that run externally to the database.

    Rate this question:

  • 2. 

    In a web application, on whic tier does the application software run? (choose the best answer)

    • A.

      In the web browser on the client tier.

    • B.

      On the middle tier

    • C.

      Within a Java-enables database.

    Correct Answer
    B. On the middle tier
    Explanation
    B. In the three-tier web application, the application software resides on the middle tier. A is wrong because client tier manages only the user interface. C is wrong because the database tier manages only the data access.

    Rate this question:

  • 3. 

    For what data storage paradigm must data be normalized (choose the best anwer).

    • A.

      Hierarchical databases

    • B.

      Network databases

    • C.

      Object-oriented databases

    • D.

      Relational databases

    Correct Answer
    D. Relational databases
    Explanation
    D. Normalization is the process of converting data to two-dimensional relational tables. A,B,C. Hierarchical, network and object-oriented databases do not implement normalized data structures.

    Rate this question:

  • 4. 

    What type of relationship should be avoided when normalizing data? ( choose the best answer)

    • A.

      One-to-many

    • B.

      Many-to-one

    • C.

      Many-to-many

    • D.

      One-to-one

    Correct Answer
    C. Many-to-many
    Explanation
    C Many-to-many relationships should be resolved into 0ne-to-one many relationships, by inserting another entity between the two.
    A, B, and D. These are all acceptable in the third normal form model.

    Rate this question:

  • 5. 

    Which of these is not a SQL command? (Choose the best answer).

    • A.

      MERGE

    • B.

      UPSERT

    • C.

      COMMENT

    • D.

      SAVEPOINT

    • E.

      All the above are SQL commands

    Correct Answer
    B. UPSERT
    Explanation
    B. The UPSERT command does not exist--though some developers refer to a MERGE operation as an UPSERT.
    A,C,C and E. MERGE, COMMENT, and SAVEPOINT, are all SQL Commands.

    Rate this question:

  • 6. 

    With regard to ensuring that data will not be lost and that security will not be compromised what would not normally be part of the DBA's duties? (choose the best answer)

    • A.

      Designing back routines

    • B.

      Setting up disk mirroring

    • C.

      Creating and dropping database objects

    • D.

      Testing restore and recovery strategies

    Correct Answer
    B. Setting up disk mirroring
    Explanation
    B. Disk administration is usually the responsiblity of the system administrators, not the database administrator.
    A,C, and D. These are typically all part of the DBA's work.

    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 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Mar 28, 2009
    Quiz Created by
    Danial98
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.