Oracle Database Administration I — Question 167

Which two Oracle database space management features require the use of locally managed tablespaces? (Choose two.)

Answer options

• A. Automatic data file extension (AUTOEXTEND)
• B. Server-generated tablespace space alerts
• C. Online segment shrink
• D. Free space management with bitmaps
• E. Oracle Managed Files (OMF)

Correct answer: C, D

Explanation

The correct answers are C and D because online segment shrink and free space management with bitmaps are functionalities that specifically require locally managed tablespaces for efficient space management. Options A, B, and E do not depend on locally managed tablespaces and can function with traditional tablespaces.