RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing DB Objects
Backup Recovery
Admin Tasks
DB Creation
«Prev
Next»
Creation Architecture
SQL*Plus
Describe Command
Spool Command
Database Architecture
Cycles Redo Log Files
Redo Log Info
Extract TS Information
Instance Architecture
Difference instance Database
Instance Overview
Asynchronous Process Coordination
System Global Area
System Monitor Process
Oracle Process Monitor
dbw0 Database Writer
Database Writing Time period
Writing Dirty Buffers
Checkpoint Trigger Database
Limiting Dirty Buffers
lgwr Log Writer
Llog Writing Process
Oracle Archiver Process
Archive Log List
CKPT Checkpoint Process
Other Oracle Processes
Memory Architecture
Database Buffer Cache
Oracle Shared Pool
Large Pool
Program Global Area
PGA DBWR SGA
PGA Contents
SharedServer PGA
Sort Area
Shared Server Areas
Database Creation
Redo Log File Sizes
Config Files
DBCreate Commands
Create Database Command
Create Oracle Service
Running pupbld Script
Starting Oracle Instance
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