Controlfile DB Parameters   «Prev  Next»
 

Recreating Control Files in Oracle - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. What does Oracle generate when backing up a control file to trace?
Please select the best answer.
  A. A debug file showing discrepancies in the database control file
  B. A copy of the control file, written to the database alert log
  C. A binary dump of control file information, written to a trace file
  D. A file with the necessary commands to re-create the control file

2. Which of the following commands do you use to back up a control file to trace?
Please select the best answer.
  A. ALTER SYSTEM BACKUP CONTROLFILE TO TRACE;
  B. ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
  C. ALTER SESSION BACKUP CONTROLFILE TO TRACE;
  D. ALTER CONTROLFILE BACKUP CONTROLFILE TO TRACE;

3. After you've generated a control file backup to trace, how do you go about finding the correct trace file?
Please select the best answer.
  A. Server Manager will tell you the filename used for the trace file generated as a result of backing up the control file to trace. You'll find the file in the user dump destination.
  B. Server Manager will prompt you to supply a trace filename when you back up the control file. You'll find the resulting file in the database's user dump destination.
  C. You look at the trace files created at the time that you issued the command to make the backup, and find the one with a CREATE CONTROLFILE statement in it.
  D. After you've created the control file backup, you have to issue the command ALTER DATABASE DISPLAY TRACE BACKUP FILE.

4. Which reason is not a good reason to re-create the control file for a database by using the CREATE CONTROLFILE command found in the trace file?
Please select all the correct answers.
  A. A catastrophic disk failure has caused you to lose all your control file copies.
  B. The existing control files have become worn out as a result of being updated too often.
  C. You have moved several database files, and you need to tell Oracle the new locations.
  D. You want to increase the value of MAXDATAFILES so that you can add more data files to the database.