Physical Backups  «Prev  Next»

Monitoring Database Backup using Oracle - Quiz

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

1. Choose three occasions when the control file must be backed up:
Please select all the correct answers.
  A. After creating a table
  B. After changing to ARCHIVELOG
  C. After every log switch
  D. After adding a datafile to a tablespace
  E. After changing to NOARCHIVELOG mode

2. Which of the following commands creates a text command file that can be used to create a new control file?
Please select the best answer.
  A. ALTER DATABASE BACKUP CONTROLFILE TO TRACE
  B. ALTER DATABASE BACKUP CONTROLFILE TO 'c:\backup\control.bak'
  C. ALTER DATABASE ARCHIVELOG
  D. ALTER SYSTEM SWITCH LOGFILE