DB Creation   «Prev  Next»

Optimal Flexible Architecture - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. What does OFA stand for in Oracle installation guidelines?
Select the best answer.
  A. Oracle Flexible Architecture
  B. Optimal Flexible Architecture
  C. Optimal File Architecture
  D. Oracle File Administration

2. On Linux or UNIX, which environment variable identifies the Oracle base directory for a database software installation owner?
Select the best answer.
  A. ORACLE_TOP
  B. ORACLE_HOME
  C. ORACLE_DIR
  D. ORACLE_BASE

3. Which two practices are consistent with OFA goals?
Select all correct answers.
  A. Distribute database I/O appropriately across the available storage.
  B. Guarantee recovery from every storage failure without backups.
  C. Require every database file to be distributed over a LAN.
  D. Organize Oracle software, database files, and administrative files separately.

4. In a traditional OFA administrative layout, which directory can hold a text PFILE for a database identified as PROD?
Select the best answer.
  A. $ORACLE_BASE/admin/PROD/pfile
  B. $ORACLE_BASE/admin/pfile
  C. $ORACLE_HOME/PROD/admin/pfile
  D. $ORACLE_BASE/PROD/admin/pfile

5. When manually naming a data file for the USERS tablespace, which choice combines the tablespace name, a sequence number, and a .dbf extension?
Select the best answer.
  A. USERS01.DBF
  B. USERS_TABLESPACE.DBF
  C. USER
  D. USER_DATA.DBF