When changing the value of minextents that is in an

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: , 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 tablespace. 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 block size. 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 QUESTION 139: 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.

Ask a homework question - tutors are online