RelationalDBDesign
Technology
Search
SiteMap
RedhatLinuxSys
Seomining
Advanced Oracle Tuning
Advanced SQL
Backup Recovery Options
Basic SQL
DB Admin Features
DB Creation Architecture
Extended DB Features
Managing DB Objects
Managing Connectivity
Network Configuration
Oracle BU Features
Oracle DB Recovery
Network Administration
Oracle Network Topology
Oracle SQL Extensions
Oracle SQL Tuning
8i PL/SQL Programming
Performance Tuning
PL/SQL Stored Objects
PL/SQL Programming
Relational DB Analysis
Relational DB Design
Tech Interview Questions
Tuning Oracle Instance
DB Creation Architecture
Oracle Server Manager
Oracle DB Architecture
Oracle Instance Architecture
Oracle Memory Architecture
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;
Score =
Correct answers:
Explanation
