RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing Objects
Backup Recovery
Admin Tasks
Memory Processes
«Prev
Next»
Backup Recovery
Backup Considerations
DBA Responsibilities
DBA Role Considerations
Operational Considerations
Technical Considerations
Disaster Recovery Plan
Plans Testing
Backup Recovery Strategy
Oracle Memory Processes
Oracle Instance Structure
DBWR Arch Process
Oracle Recovery Data Structures
DB Configuration File
Database Control File
Control File Maintenance
RedoLog Files
Writing Redo Log Files
Multiplexing Redo Log
Archive Log Files
Checkpoint Process
Physical File Placement
State Structure Database
File Components Conclusion
Archivelog Noarchivelog
Physical Logical Backups
Archivelog Mode
Archiving Options
Archive Process Options
Normal Arch Processing
Manual Archiving
Auto ArchiveLog Options
Retrieve ArchiveLog
Standby Database
VM Conclusion
Memory Process Files - Quiz
Each question is worth one point. Select the best answer or answers for each question.
1.
Which of the following processes write data from the SGA to disk?
Please select
all the correct answers
.
A.
User processes
B.
DBWR
C.
ARCH
D.
SMON
2.
Which of the following memory structures is required for the instance to start?
Please select
all the correct answers
.
A.
Data buffer cache
B.
Redo log buffers
C.
Large pool
D.
Shared pool
3.
Which file structure contains before and after images of modified data for recovery purposes?
Please select
the best answer
.
A.
Redo log files
B.
Control files
C.
Data files
D.
Parameter files
4.
Where are you likely to find redo log files if you've performed a default Oracle8 installation and your Oracle_Home is c:\oracle8?
Please select
the best answer
.
A.
C:\oracle8\redo
B.
C:\oracle8\datafile
C.
C:\oracle8\database
D.
C:\oracle8\temp