Multiple choice technology databases

You specified segment space management as automatic for a tablespace what effect would this have on space management?

  1. Extents would be managed by freelists.

  2. Free space would be managed by data dictionary.

  3. The segment would be managed by bitmaps.

  4. The segment would be managed by freelists.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Automatic Segment Space Management (ASSM) uses bitmaps to track free space within segments, replacing traditional freelist management. When you specify segment space management as automatic, Oracle uses bitmap-based space tracking. Freelists and data dictionary management are manual space management techniques.

Keep practicing — related questions