Multiple choice technology databases

SQL> CREATE TABLESPACE user_data EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; Which twp assumptions must be true for this statement to execute successfully ? (Choose two)

  1. Oracle Managed Files used for this instance.
  2. The USER_DATA tablespace in managed using FET$/UET$ tables.

  3. The COMPATIBLE intialization paramter must be 9.0.0 or higer.

  4. Space within segments is the USER_DATA tablespace is managed with freelists.
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

Locally managed tablespaces with automatic segment space management require: Oracle Managed Files (OMF) for automatic file handling, and COMPATIBLE parameter set to 9.0.0 or higher for LMT + ASSM support. FET$/UET$ are used in DICTIONARY-managed tablespaces (not locally managed), and freelists are manual segment management (not automatic).

Keep practicing — related questions