RelationalDBDesign RelationalDBDesign


Recovery File Structures   «Prev 
 

Oracle Database Installation - Quiz

Each question is worth one point. Select the best answer or answers for each question.


1. In a default installation with your ORACLE_HOME as c:\oracle8 and your database as ORC1, where will you likely find the file initorc1.ora?
Please select the best answer.
  A. C:\oracle8

  B. C:\oracle8\bin

  C. C:\oracle8\database

  D. C:\oracle8\sysman



2. Which of the following files should you backup on a regular basis?
Please select all the correct answers.
  A. initorc1.ora

  B. ctr1orc1.ora

  C. index table spaces

  D. All the files in the ORACLE_HOME directory



3. Assuming that you have made no database structure modifications, what will guarantee a point in time recovery of your database after a complete system crash two days after your last complete system backup?
Please select the best answer.
  A. Backed up copies of your control files, init.ora files, and your redo log files from both days

  B. Backed up copies of your redo log files from both days and your control files

  C. Backed up copies of your redo log files from both days

  D. Backed up copies of your archive log files



4. What will happen if LGWR has a problem writing to one redo log member in a multiplexed redo log group?
Please select the best answer.
  A. LGWR will terminate bringing the database down.

  B. LGWR will continue writing to the other redo log file.

  C. LGWR will close the bad redo log file, create a new one and then continue processing.

  D. LGWR will drop the group and continue processing as long as there are two groups available.



5. If your control files are corrupt and you cannot bring the database back up, how can you recreate them?
Please select the best answer.
  A. Delete the bad control file and restore a backup copy.

  B. Using server manager, connect as internal and start the database with nomount. Then issue the command

  C. Alter database restore backup controlfile.

  D. Using server manager, connect as internal and start the database with nomount. Use the output from alter database backup controlfile to trace to recreate the control file. Then restart the database.

  E. Using server manager, connect as internal and start the database with nocontrolfile. Then issue the command Alter database create controlfile c:\oracle8\database\ctl1orc1.ora. Bring the database down and then back up.



6. A control file contains the following information:
Please select all the correct answers.
  A. Names and locations of associated data files and redo log files

  B. Current log sequence number

  C. Checkpoint information

  D. Archive log information