RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing DB Objects
Backup Recovery
Admin Tasks
Database Architecture
«Prev
Next»
Creation Architecture
SQL*Plus
Oracle SQL*Plus
Locating Oracle Home
Shared Server Executable
Starting Shared Server
Shared Server Commands
Disconnect Command
Potential Mistake-commands
Shared Server Help
Describe Command
Spool Command
Execute SQL
Shared Server Conclusion
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
System Global Area
Database Buffer Cache
Multiple Buffer Pools
Redo Log Buffer
Oracle Shared Pool
SQL Command Matching
Large Pool
Program Global Area
PGA Contents
Sort Area
Memory Architecture Conclusion
Database Creation
Database Environment
OFA
DB Initialization File
Determining file Location
Set Block Size
Initial DB Files
Sizing SGA
Database Parameters
DB Preparation Conclusion
DBCreate Commands
Create Database Command
Create Oracle Service
Starting Oracle Instance
Execute Create DB Command
Change System Password
Data Dictionary Scripts
Running catproc Script
Running pupbld Script
Session Control Oracle23c
Creating Initial Tablespaces
Creating Rollbac Ssegments
Creating DBs Conclusion
Oracle Redo Log - Quiz
Each question is worth one point. Select the best answer for each question.
1.
Why does Oracle recommend multiplexing your redo log files, and storing each member on separate disks?
Please select the best answer.
A.
To use as many disks as possible, thus maximizing disk utilization
B.
To preserve the redo log in the event that one disk is damaged
C.
To increase the number of log switches
D.
To concentrate all redo log input on one disk controller
2.
Which of the following SQL queries will give you a list of your redo log files?
Please select the best answer.
A.
SELECT log_file_name FROM dba_log_files;
B.
SELECT member FROM v$log;
C.
SELECT member FROM v$logfile;
D.
SELECT log_member FROM V$LOG_FILES;
3.
What is the difference between a redo log group and a redo log member?
Please select the best answer.
A.
A redo log group is a single physical file; a member is the logical name
B.
A redo log group contains one or more identical members (copies of the same redo log)
C.
A redo log member contains multiple groups
D.
There is no difference — the terms are interchangeable
4.
Which of the following is the best practice for sizing Oracle redo log files?
Please select the best answer.
A.
Make them as small as possible to force frequent log switches
B.
Size them so that log switches occur approximately every 15–30 minutes under normal load
C.
Make all redo logs 100MB regardless of database workload
D.
Size them based only on the size of the largest transaction