New Features for Administrators - Question 052

Which two are true regarding automatic space management segments? (Choose two.)

A. You can create an automatic space management segment in a dictionary-managed tablespace.

B. You can create an automatic space management segment only in a locally managed tablespace.

C. You can successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment.

D. You CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment.

Answer: B, D

Explanation:

You can create an automatic space management segment only in a locally managed tablespace. The FREE_BLOCKS procedure refers to the blocks in a segment below the high water mark whose number of rows falls below the PCTUSED attribute, and therefore are candidate for new inserted rows. An automatic space management segment usage eliminates the need to specify the PCTUSED, FREELISTS, and FREELIST GROUPS parameters. So you CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment.

Incorrect Answers

A: You can create an automatic space management segment only in a locally managed tablespace, not in a dictionary-managed tablespace..

C: You CANNOT successfully invoke the DBMS_SPACE.FREE_BLOCKS procedure on an automatic space management segment because of eliminating the need to specify the PCTUSED, FREELISTS, and FREELIST GROUPS parameters in an 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