Multiple choice technology databases

Which is the smallest logical unit in Oracle database?

  1. Extent

  2. Block

  3. Segment

  4. Table

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

The block is the smallest logical unit in Oracle database storage. Multiple contiguous blocks form an extent, multiple extents form a segment, and segments are stored in tablespaces. Blocks are the fundamental unit of I/O operations.