This preview shows page 1. Sign up to view the full content.
Unformatted text preview: when defined in a tablespace, cannot be overridden. That
option is MINIMUM EXTENT, which ensures that every extent size used in the tablespace is a
multiple of the specified integer value. But this option does not specify the initial size of a
D: The sum of the INITIAL and NEXT clauses of the CREATE TABLESPACE statement do
not determine the initial size of a tablespace.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 337-342
Chapter 7: Managing the Physical Database Structure
What can a permanent tablespace contain? Actualtests.com - The Power of Knowing 1Z0-023
A. Only temporary segments.
B. Only permanent segments.
C. Both temporary and ordinary segments.
D. Both permanent and temporary segments.
Answer D is correct. Users can be assigned to either permanent or temporary tablespaces for
creating temporary segments. If the user assigned to a permanent tablespace for creating
temporary segments, the temporary segment will be created at the time the disk sort is required.
A: A permanent tabl...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09