RelationalDBDesign RelationalDBDesign


Physical Backups  «Prev  Next»

Monitoring Database Backup using Oracle - Quiz

Control file database backup issues

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