Physical Backups  «Prev  Next»

Read Only Backups - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. What is a potential advantage of NOLOGGING for a qualifying direct-path load or index creation when effective FORCE LOGGING does not override it?
Please select the best answer.
  A. It eliminates redo for every conventional INSERT, UPDATE, and DELETE on the object.
  B. It prevents online redo log switches until the operation finishes.
  C. It reduces redo for the qualifying operation, potentially improving performance, but can leave changes that an earlier backup plus redo cannot reconstruct.
  D. It disables archiving for the entire database.

2. Which database file maintains structural and recovery metadata about a tablespace changing to READ ONLY?
Please select the best answer.
  A. The CDB control file.
  B. The server parameter file (SPFILE).
  C. The password file.
  D. A temporary tablespace tempfile.

3. Which statement correctly describes the backup strategy for a tablespace after its transition to READ ONLY has completed?
Please select the best answer.
  A. Its backup protects every writable tablespace in the CDB as well.
  B. It must be changed back to READ WRITE before its datafiles can be backed up.
  C. Its read-only status protects it from storage failure, so no backup is needed.
  D. Take a post-transition backup and retain usable copies; unchanged contents can reduce repeated backup work while the tablespace remains read-only.

4. Which statement correctly describes how RMAN handles read-only datafiles in database backups?
Please select the best answer.
  A. RMAN always excludes read-only datafiles from BACKUP DATABASE.
  B. Read-only status alone does not exclude them; SKIP READONLY explicitly skips them, while backup optimization can skip identical files when its criteria are met.
  C. SKIP READONLY validates an existing backup before omitting each read-only datafile.
  D. Backup optimization permanently prevents another backup of a file once it becomes read-only.

5. RO_SAMPLE has a validated read-only backup. A DBA changes it to READ WRITE and modifies its data. What should the backup strategy do?
Please select the best answer.
  A. Resume normal backup and applicable redo protection, review persistent exclusions, and take a new baseline if it becomes read-only again after the changes.
  B. Continue using only the old read-only backup because it automatically contains subsequent changes.
  C. Delete all earlier backups immediately because changing to READ WRITE makes them unusable for every recovery target.
  D. Back up only the control file because it contains the modified table rows.