RelationalDBDesign RelationalDBDesign


Controlfile DB Parameters   «Prev 
 

Multiplexing Control Files - Quiz

1. When deleting a control file, what two things must you do?
Please select the best answer.
  A. Remove the file's name from the control_file initialization parameter in your database's initialization file and restart the database.
  B. Restart the database and then remove the control file's name from the list specified for the control_files initialization parameter.
  C. Copy the control file and then remove the control file's name from the list specified for the control_files initialization parameter.
  D. Copy the control file and remove the control_file initialization parameter from your database's initialization file.

2. Why should you multiplex your database control file?
Please select the best answer.
  A. To spread control file input/output evenly across as many drives as possible
  B. To increase the performance of your database
  C. To ensure that losing any one disk does not cause you to lose the control file
  D. To add more space for Oracle to use in recording information about the database

3. When adding a new control file to a database, what must you do before copying one of the existing control files?
Please select the best answer.
  A. Take that file offline using the ALTER CONTROLFILE command.
  B. Place an entry in the parameter file for the new control file.
  C. Turn archiving off so that checkpoints are not recorded.
  D. Shut down the database to ensure that the control file is closed.

4. What are two key things you must be sure of when adding or removing control files?
Please select all the correct answers.
  A. The database is shut down when copying or deleting existing redo log files.
  B. You issue the ALTER CONTROLFILES command to tell Oracle of the changes.
  C. Archivelog mode is enabled so that control file changes are recorded in the redo log.
  D. The control_files parameter reflects the correct list of files when restarting the database.