Question

What is the use of extent in Oracle?

(a) Stores user data within the database

(b) Stores rollback information used when data must be rolled back

(c) Minimize the amount of wasted (empty) storage

(d) None of the Mentioned

I had been asked this question during an online exam.

Asked question is from Oracle Database 11g Architecture topic in chapter Oracle Database 11g Architecture Options of Oracle

Answer 1

Correct option is (c) Minimize the amount of wasted (empty) storage

The explanation is: An extent is a logical unit of database storage space allocation made up of a number of contiguous data blocks.