Oracle Database Administration I — Question 87

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces? (Choose three.)

Answer options

• A. Oracle Managed Files (OMF)
• B. Online table segment shrink
• C. Online index segment shrink
• D. Automatic data file extension (AUTOEXTEND)
• E. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR)

Correct answer: A, D, E

Explanation

Oracle Managed Files (OMF), Automatic data file extension (AUTOEXTEND), and Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR) are features that function with both types of tablespaces. In contrast, Online table segment shrink and Online index segment shrink are specific to locally managed tablespaces and do not apply to dictionary-managed tablespaces.