This preview shows page 1. Sign up to view the full content.
Unformatted text preview: an contain permanent segments.
C. Tempfiles are always set to LOGGING mode.
D. Tempfiles are used for all types of temporary tablespaces.
E. You cannot create a tempfile with an ALTER DATABASE command.
F. BACKUP CONTROLFILE generates commands to recreate lost tempfiles.
Answer: A, E
Answers A, E are correct. Tempfiles are used temporary, so no information is stored in redo logs
about them. Media recovery will not recover tempfiles. A tempfile can not be created explicitly
with ALTER DATABASE command.
B: Tempfiles cannot contain permanent segments.
C: Tempfiles does not produce any entries for redo logs, they are always in NOLOGGING
D: Tempfiles are used not for all types of temporary tablespaces.
F: BACKUP CONTROLFILE does not generate any command to recreate lost tempfile.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 1146
Chapter 24: Oracle8i New Features Topics
When you created a tablespace, you overestimated the size of one of the datafiles. Several
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09