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. Which three changes require ensuring that a new control-file backup reflects the changed database configuration?
Please select all the correct answers.
  A. Creating a table in an existing tablespace without adding or changing database files
  B. Changing the database to ARCHIVELOG mode
  C. An ordinary redo log switch
  D. Adding a datafile to a tablespace
  E. Changing the database to NOARCHIVELOG mode

2. Which command writes SQL statements to a trace file that can be used to re-create the control file?
Please select the best answer.
  A. ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
  B. ALTER DATABASE BACKUP CONTROLFILE TO '/backup/control.bak';
  C. ALTER DATABASE ARCHIVELOG;
  D. ALTER SYSTEM SWITCH LOGFILE;

3. Which dynamic performance view reports RMAN backup-job status, start time, and end time?
Please select the best answer.
  A. V$BACKUP
  B. V$DATAFILE_HEADER
  C. V$RMAN_BACKUP_JOB_DETAILS
  D. DBA_DATA_FILES

4. For a datafile, what does a STATUS value of ACTIVE in V$BACKUP indicate?
Please select the best answer.
  A. RMAN is currently copying that datafile
  B. The datafile is in user-managed backup mode
  C. The latest backup of that datafile passed restore validation
  D. An operating system copy of that datafile has completed successfully

5. What does the RMAN command RESTORE DATABASE VALIDATE do?
Please select the best answer.
  A. Lists backup records without reading backup contents
  B. Creates a new backup of the current database
  C. Restores the database files and applies all required redo
  D. Reads the backups selected for a database restore and checks them without writing restored datafiles