New Features for Administrators - Question 055

Examine the statement:

SQL> CREATE TABLESPACE user_ data
2> EXTENT MANAGEMENT LOCAL
3> SEGMENT SPACE MANAGEMENT AUTO;

Which two assumptions must be true for this statement to execute successfully? (Choose two.)

A. Oracle Managed Files are used for this instance.

B. The USER_DATA tablespace is managed using FET$/UET$ tables.

C. The COMPATIBLE initialization parameter must be 9.0.0 or higher.

D. Space within segments in the USER_DATA tablespace is managed with freelists.

Answer: A, C

Explanation:

Oracle Managed Files are used for this instance. To use automatic space management segment the COMPATIBLE initialization parameter in the init.ora file must be 9.0.0 or higher.

Incorrect Answers

B: The USER_DATA tablespace is not managed using FET$/UET$ tables.

D: Because of automatic space management segment usage the USER_DATA tablespace cannot be managed with freelists.

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