RelationalDBDesign RelationalDBDesign


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

Correct answers:

Your Score: 0