Multiple choice technology databases

Choose the correct hierarchy, from largest to smallest, from this list of logical database structures.

  1. Database, tablespace, extent, segment, block

  2. Database, tablespace, segment, extent, block

  3. Database, segment, tablespace, extent, block

  4. Database, extent, tablespace, segment, block

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The correct hierarchy is Database (largest) → Tablespace → Segment → Extent → Block (smallest). A tablespace contains segments (like tables or indexes), segments are made of extents, and extents are contiguous blocks.