New Features for Administrators - Question 068

Which three parameters are ignored when creating an automatic space management segment? (Choose three.)

A. PCTFREE

B. PCTUSED

C. INITRANS

D. MAXTRANS

E. FREELISTS

F. FREELIST GROUPS

Answer: B, E, F

Explanation:

PCTUSED, FREELISTS and FREELIST GROUPS parameters are ignored when creating an automatic space management segment. Oracle9i automatic segment space management maintains information about datablock space utilization in bitmaps, as opposed to freelists.

Incorrect Answers

A: Usage of automatic space management segment will not eliminate the need to specify the PCTFREE parameter.

C: The INITRANS parameter is also used for automatic space management segment.

D: The MAXTRANS parameter is also used for automatic space management segment.

OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 138-140

Chapter 3: Manageability Enhancements

Oracle 9i New Features, Robert Freeman, p. 53-54

Chapter 2: Oracle9i Architecture Changes