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
Database File Types
Initialization File
Database Control File
Oracle Datafiles
Oracle Tablespaces
Extract TS Information
Redo Logs Crash-recovery
Preserve Redo Logs
Cycles Redo Log Files
Redo Log Info
Archived Redo Logs
Architecture Conclusion
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
Preparing to create an Oracle Database - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which initialization parameter cannot be changed after the database has been created?
Please select the best answer.
A.
compatibility
B.
db_block_size
C.
control_files
D.
db_files
2.
For which type of system is a larger block size usually appropriate?
Please select the best answer.
A.
A decision support system
B.
A transaction processing system
C.
An artificial intelligence system
D.
An intelligent agent system
3.
If you do not have enough redo log files, or if the files are not large enough, which two events could occur?
Please select all the correct answers.
A.
Checkpoints will not complete in time.
B.
Oracle will only be able to write one redo log file at a time.
C.
A redo log file might not be archived before it is time to reuse it.
D.
Oracle will run out of space in the redo log file before a transaction completes.
4.
When you size the SGA, why should you be careful not to make it too large?
Please select the best answer.
A.
The larger the SGA is, the less room you have for the database buffer cache.
B.
An overly large SGA can overflow into the shared pool and overwrite your execution plans.
C.
Too large a database buffer cache slows performance because Oracle is forced to fill it.
D.
You don't want the SGA to be paged out to disk because it is too large to fit in memory.
5.
The database block size should be an integer mulitple of another value. What is that value?
Please select the best answer.
A.
The row size of your largest table
B.
The operating system block size.
C.
The control file size
D.
The word size for your CPU
x