Oracle Database 11g: Administration I — Question 19

Which structure can span multiple data files?

Answer options

• A. a bigfile tablespace
• B. an extent
• C. a temporary tablespace
• D. a permanent tablespace
• E. a segment

Correct answer: E

Explanation

A segment is the correct answer as it can span multiple data files within a tablespace. In contrast, a bigfile tablespace and a permanent tablespace may contain multiple files but do not themselves span files. An extent is a smaller unit of storage, and a temporary tablespace is primarily used for transient data and does not support spanning across files in the same manner as a segment.