Multiple choice

Identify the complete list of the logical components of an Oracle database.

  1. Tablespaces, segments, extents, and data files

  2. Tablespaces, segments, extents, and Oracle blocks

  3. Tablespaces, database, segments, extents, and data files

  4. Tablespaces, database, segments, extents, and Oracle blocks
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The correct answer is B because Oracle blocks are the smallest unit of logical storage allocation, while data files are physical storage structures. The logical hierarchy flows from tablespaces (largest) down to Oracle blocks (smallest): tablespaces contain segments, segments contain extents, and extents contain Oracle blocks. Option A incorrectly includes data files which are physical, not logical. Options C and D incorrectly include 'database' as a component within the hierarchy.

Keep practicing — related questions