Database Architecture   «Prev  Next»

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;

Correct answers:

Your Score: 0