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 the advantage of the NOLOGGING option for a table, index or partition?
Please select the best answer.
  A. No redo is generated for INSERTS, UPDATES, or DELETES occurring on the affected object(s)
  B. No log switches occur during INSERTS
  C. No redo is generated during direct-load INSERT operations occurring on the affected object(s)
  D. No archive logs are created

2. Which of the following database file(s) are affected by ALTER TABLESPACE <tablespace> READ ONLY?
Please select the best answer.
  A. The control file
  B. DBWR
  C. Files belonging to tablespace SYSTEM
  D. LGWR

3. Which statement correctly describes an attribute of Oracle read-only backups?
Please select the best answer.
  A. Oracle read-only backups can be performed while the database is open and require the database to be in ARCHIVELOG mode.
  B. Oracle read-only backups allow updates to the data files during the backup process to ensure the most current data is captured.
  C. Oracle read-only backups can only be accomplished through RMAN (Recovery Manager) with the database in NOARCHIVELOG mode.
  D. Oracle read-only backups require the database instance to be shut down before the backup can commence.

Correct answers:

Your Score: 0