Unformatted text preview: The Power of Knowing 1Z0-025
checkpoints. When database data is defined as read-only, the DBA needs to back up the
read-only tablespace once, after the status of the tablespace is changed to read-only.
C: Oracle automatically does not mean the file for backup, it's DBA's responsibility to
backup datafiles of tablespace, when it became read-write.
D: There is no object integrity check after tablespace status change.
E: The DBWn process writes to the data files of the tablespace only if it will be changes
in data of tablespace, not because of tablespace status change.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 593
Chapter 12: Overview of Backup and Recovery
Why would a DBA load a table using the NOLOGGING options?
A. To eliminate further backup.
B. To temporarily disable collecting statistics.
C. To reduce redo during a direct loaded operation.
D. To specify that the retrieved for this table are placed at the least recently-used end of
the buffer cache.
View Full Document
- Fall '09
- Jason S. Couchman, DBA Certification Exam, Certification Exam Guide