Physical Backups  «Prev 

Archiving Physical Backups - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which statement best describes a fuzzy datafile backup?
Please select the best answer.
  A. It is a consistent file copy that never requires redo after restoration.
  B. It is a special backup mode entered only by issuing BEGIN BACKUP.
  C. Its blocks are not checkpoint-consistent, so media recovery is required after restoration to establish a consistent recovery point.
  D. It necessarily contains fractured blocks and therefore cannot be recovered.

2. A DBA plans a user-managed operating-system copy of an online read/write tablespace. With appropriate privileges, file inventory, and backup destinations prepared, which sequence is correct?
Please select the best answer.
  A. Leave the database in NOARCHIVELOG mode, copy the active datafiles, and enable archiving afterward.
  B. Copy the active datafiles first, then issue BEGIN BACKUP and END BACKUP to make the completed copy consistent.
  C. Start an archiver process and copy the active datafiles without verifying the database logging mode or using backup mode.
  D. Confirm ARCHIVELOG mode and the open database state; begin backup mode for the tablespace, copy all its datafiles, end backup mode, and archive and protect the required redo.

3. Which SQL command creates a binary control-file backup, assuming an authorized CDB-root connection, a valid destination path, and a destination file that does not already exist?
Please select the best answer.
  A. ALTER DATABASE BACKUP CONTROLFILE TO '/backup/control.bak';
  B. ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
  C. ALTER TABLESPACE users BEGIN BACKUP;
  D. ARCHIVE LOG LIST

4. Which statement correctly distinguishes V$DATAFILE_HEADER.FUZZY from V$BACKUP.STATUS?
Please select the best answer.
  A. END BACKUP always changes FUZZY from YES to NULL, and NULL proves that the backup is consistent.
  B. FUZZY reports file-header consistency information using YES or NO; V$BACKUP.STATUS identifies user-managed backup mode with statuses such as ACTIVE and NOT ACTIVE.
  C. FUZZY = YES proves that an operating-system copy is currently running.
  D. V$BACKUP.STATUS must be ACTIVE whenever RMAN is backing up a datafile.

5. Which two actions correctly protect a tablespace as it changes between READ ONLY and READ WRITE?
Please select exactly two answers.
  A. Create a new backup with every subsequent database backup, even while the contents remain unchanged, because read-only backups expire at the next checkpoint.
  B. When it becomes READ WRITE, resume normal backup and applicable redo protection, and review persistent exclusions.
  C. Take only a pre-transition backup and discard the redo needed to recover any changes made before the READ ONLY transition completes.
  D. After the READ ONLY transition completes, take a backup and retain usable, validated copies while the data remains needed.