OCA - Oracle Database Administration Test Quiz

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

Hierarchical databases

Network databases

Object-oriented databases

Relational databases

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.

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.

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

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.

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.

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

MERGE

UPSERT

COMMENT

SAVEPOINT

All the above are SQL commands

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.

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.

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.

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.

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.

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.

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.

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.

Submit

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

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.

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.