OCA - Oracle Database Administration Test Quiz

6 Questions | By Danial98 | Updated: Mar 21, 2022 | Attempts: 6020

Questions

Settings

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