Multiple choice technology programming languages

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 uses bitmaps to track free and used space within segments instead of freelists. When you specify automatic segment space management for a tablespace, Oracle uses bitmaps to manage space allocation, which is more efficient than the manual freelists method. Freelists (A and D) are used in manual segment space management, while data dictionary (B) management is an older, deprecated approach.

Keep practicing — related questions