RelationalDBDesign RelationalDBDesign


Physical Backups  «Prev  Next»

Performing Database Backup - Quiz

Each question is worth one point. Select the best or answers for each question.
 
1. Choose two advantages of an open ARCHIVELOG database backup over a closed NOARCHIVELOG database backup.
Please select all the correct answers.
  A. Takes less time than a cold backup
  B. Requires less training
  C. Allows recovery to point-in-time
  D. Can be done at the tablespace or the datafile level

2. The command ALTER TABLESPACE <tablespacename> BEGIN BACKUP; performs which of the following actions:
Please select the best answer.
  A. Begins making a backup copy of the tablespace file <tablespacename>
  B. Prevents writes to tablespace <tablespacename> until the backup is complete
  C. Can be done if the database is in NOARCHIVELOG mode
  D. Causes a checkpoint and freezes the datafile header(s) for tablespace <tablespacename>

3. Which view can be used to determine the files that need to be backed up for a given tablespace?
Please select the best answer.
  A. DBA_TABLESPACES
  B. V$DATABASE
  C. DBA_DATA_FILES
  D. V$DATABASE