OCA - Oracle Database Administration Test Quiz - Trivia , Flashcards & Questions

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 Danial98

Danial98

Community Contributor

Quizzes Created: 2 | Total Attempts: 8,705

| Attempts: 6,357

Quiz Flashcard

Questions

Feedback

During the Quiz End of Quiz

Difficulty

Easy First Hard First Sequential

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

1/6 Questions

For what data storage paradigm must data be normalized (choose the best anwer).
- Hierarchical databases
- Network databases
- Object-oriented databases
- Relational databases

About This 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.

OCA - Oracle Database Administration Test Quiz - Quiz

2.

What type of relationship should be avoided when normalizing data? ( choose the best answer)
- One-to-many
- Many-to-one
- Many-to-many
- One-to-one
Correct Answer

A. 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:
3.

Which of these is not a SQL command? (Choose the best answer).
- MERGE
- UPSERT
- COMMENT
- SAVEPOINT
- All the above are SQL commands
Correct Answer

A. 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:
4.

In a web application, on whic tier does the application software run? (choose the best answer)
- In the web browser on the client tier.
- On the middle tier
- Within a Java-enables database.
Correct Answer

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

0
5.

Which of these languages can run within the database ? (choose all correct answers).
- C.
- Java
- PL/SQL
- SQL
- Any other language, if it is linked with OCI libararies.
Correct Answer(s)

A. Java
A. PL/SQL
A. 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
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)
- Designing back routines
- Setting up disk mirroring
- Creating and dropping database objects
- Testing restore and recovery strategies
Correct Answer

A. 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 (Updated): Mar 21, 2023 +

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

OCA - Oracle Database Administration Test Quiz

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

Quiz Preview

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

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

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

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

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)