Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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 Explanation: 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. Incorrect Answers: B: Tempfiles cannot contain permanent segments. C: Tempfiles does not produce any entries for redo logs, they are always in NOLOGGING mode. 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 QUESTION 71: When you created a tablespace, you overestimated the size of one of the datafiles. Several object...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online