Oracle Database Administration I — Question 153

Which two statements are true about segment types in an Oracle Database? (Choose two.)

Answer options

• A. Temporary segments are only stored in a temporary tablespace.
• B. Index segments always have two or more extents.
• C. Undo segments are only stored in an undo tablespace.
• D. Cluster segments may contain data from multiple tables.
• E. Table segments always have two or more extents.

Correct answer: A, C

Explanation

Answer A is correct because temporary segments are indeed stored only in temporary tablespaces. Answer C is also correct as undo segments are specifically stored in an undo tablespace. The other options are incorrect; for instance, index segments do not necessarily have two or more extents, cluster segments can contain data from multiple tables, and table segments do not always have two or more extents.