Multiple choice

Which of the following options lists the correct hierarchy of storage structures, from largest to the smallest?

  1. Segment, extent, tablespace, data block

  2. Data block, extent, segment, tablespace

  3. Tablespace, extent, data block, segment

  4. Tablespace, segment, extent, data block
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The storage hierarchy from largest to smallest is: tablespace (logical container for segments), segment (collection of extents storing an object like a table or index), extent (contiguous data blocks), and data block (smallest unit of I/O, typically 2-32KB). This hierarchy organizes physical storage into manageable logical units.

Keep practicing — related questions