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
Oracle Memory Structures - Quiz Results
Memory Instances
Each question is worth one point. Select the best answer or answers for each question.
1.
Select the instance memory structures from the answers below.
Please select
all the correct answers
.
A.
redo log buffer
B.
SMON
C.
large pool
D.
DBWR
2.
Which
V$
view is used to request information about your shared pool size?
Please select
the best answer
.
A.
V$DATABASE
B.
V$INSTANCE
C.
V$PROCESS
D.
V$SGA
3.
If the parameter BACKUP_DISK_IO_SLAVES is set to "1" then which of the following is true?
Please select
the best answer
.
A.
The system allocates one I/O slave to manage log archiving.
B.
If the Large Pool is not being used, the system will allocate one I/O slave to be used by RMAN for read and write operations.
C.
If LARGE_POOL_SIZE is set, the system will allocate one I/O slave to be used by RMAN for read and write operations.
D.
The allocated buffer in the large pool is an asynchronous I/O buffer.
4.
Which of the processes below are required to start an instance?
Please select
all the correct answers
.
A.
DBWR
B.
LGWR
C.
CKPT
D.
ARCH