RelationalDBDesign RelationalDBDesign


Physical Backups  «Prev  Next»

Backup Options and Methods - Quiz

Each question is worth one point. Select the best answer or answers for each question.
 
1. To fully protect data in an operating Oracle database, it is important to back up the following:
Please select all the correct answers.
  A. Alert file
  B. Datafiles, redo logs, and control files
  C. Init.ora file
  D. Password files

2. Which of the following features are true about an operating system backup without archiving?
Please select all the correct answers.
  A. You can recover the database to the point of failure after a media failure.
  B. You must shut down the database cleanly before a database backup is made.
  C. You can recover the database to the point-of-time of the last backup.
  D. You can make a database backup while the database is operating.

3. Where can you find the parameter files you need to back up?
Please select the best answer.
  A. In the data dictionary view DBA_DATA_FILES
  B. In the file system of the machine on which the database server is started
  C. In the dynamic views like V$CONTROLFILE and V$LOGFILE
  D. In the online archived log files

4. Which of the following actions will produce a valid database backup?
Please select all the correct answers.
  A. To back up an ARCHIVELOG database while it is running
  B. To back up a NOARCHIVELOG database while it is running
  C. To back up an ACHIVELOG database while it is closed
  D. To back up a NOARCHIVELOG database while it is closed