RelationalDBDesign RelationalDBDesign


Recovery File Structures   «Prev  Next»

Control file maintenance - Exercise

Objective: Test your understanding of parameter information
This exercise uses a Java applet to allow you to match items in the left column with the items in the right column. If you do not have Java active in your browser or are behind a firewall that does not allow Java applets, you will not be able to complete this exercise. If you do not see the applet below, click OK, I'm Done to continue with the course.

In the left column below are 9 items with their corresponding definitions in the right column. Click a term in the left column, then click the definition in the right column to make a match.
When you have all of the terms and their definitions matched, click the Done button to see whether or not you've matched the terms correctly. Green lines mean the match is correct, red lines mean the match is incorrect. If you didn't get the matches right the first time, click Clear to erase your matches and try again.

When you complete the exercise, click the Submit button to see the correct answers.

Exercise Scoring


This exercise is unscored. It is designed to allow you to check your understanding of control files. When you are done, click the OK, I'm Done button.
  1. INIT.ORA
  2. V$SGA
  3. V$DATABASE
  4. ORC1
  5. CTR1ORC1.ORA
  6. B
  7. 32
  8. Server Manager
  9. Instance Manager
  1. Will provide redo buffer size
  2. Default MAXLOGFILE value
  3. A typical default control file name
  4. Will provide archive mode
  5. Line mode tool
  6. Default MAXLOGMEMBER value
  7. Identifies the location of your control files
  8. GUI tool
  9. A typical default database name