Unformatted text preview: , you can reduce the value from its current value, but you cannot increase it. You
cannot change the value of MINEXTENTS for an object that resides in a locally managed
D: MAXEXTENTS parameter determines the maximum number of extents that a segment can
have. Can also be specified as UNLIMITED. The minimum value is 1 (except for rollback
segments, which always have a minimum value of 2). The default value depends on your data
E: The MINIMUM EXTENT clause lets you control free space fragmentation in the tablespace
by ensuring that every used or free extent in a tablespace is at least as large as, and is a multiple
of, integer. This clause is not relevant for a dictionary-managed temporary tablespace.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 337-339
Chapter 7: Managing the Physical Database Structure
Which statement about a tablespace is true?
A. A tablespace can be read-only.
B. A tablespace must contain at least one segment.
C. A tablespace can...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09