RelationalDBDesign RelationalDBDesign


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 the abbreviation OFA stand for?
Please select the best answer.
  A. Oracle Flexible Architecture
  B. Optimal Flexible Architecture
  C. Optimal File Architecture
  D. Oracle File Administration

2. What is the name of the UNIX environment variable that points to the top-level Oracle directory?
Please select the best answer.
  A. ORACLE_TOP
  B. ORACLE_HOME
  C. ORACLE_DIR
  D. ORACLE_BASE


3. Which two of the following statements are goals of the OFA?
Please select all the correct answers.
  A. To spread I/O across as many drives as possible
  B. To promote data integrity
  C. To distribute data over a LAN
  D. To separate different types of files

4. On a typical, OFA compliant, installation, which directory would you look in to find the initialization file for the PROD database?
Please 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. Assume that you had a tablespace named USERS. Which filename listed below would be OFA compliant?
Please select the best answer.
  A. USERS01.DBF
  B. USERS_TABLESPACE.DBF
  C. USER
  D. USER_DATA.DBF