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

Danial98

Community Contributor

Quizzes Created: 2 | Total Attempts: 8,429

Questions: 6 | Attempts: 6,189 | Updated: Mar 21, 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

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

0
1
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

OCA - Oracle Database Administration Test Quiz

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

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

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

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).

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)