Managing Redo log   «Prev  Next»
 

Listing Redo LogFiles Quiz - Results



1. How do you protect yourself from losing redo log files?
Please select the best answer.
  A. Copy them to a backup tape on a frequent basis.
  B. Mirror them, so you always have multiple copies.
  C. Create more than two groups, in case one is lost.
  D. Start up the archive log utility to make copies for you.

2. For what two purposes are redo log files used?
Please select all the correct answers.
  A. Redo log files enable transactions to be recovered after a crash.
  B. Redo log files enable you to spread database I/O over several disks.
  C. Redo log files enable you to commit transactions more quickly.
  D. Redo log files enable up-to-the minute recovery after a media failure.

3. What is the best way to display a list of redo log files for your database?
Please select the best answer.
  A. Copy the contents of your database control file to the screen.
  B. Issue theSHOW LOGFILES command from Server Manager.
  C. Query the v$logfile view and look at the member column.
  D. Query the dba_logfile view and look at the member column.