Oracle Database Administration I — Question 24

Which three statements are true concerning logical and physical database structures? (Choose three.)

Answer options

• A. All tablespaces may have one or more data files
• B. The extents of a segment must always reside in the same datafile
• C. A smallfile tablespace might be bigger than a bigfile tablespace
• D. A segment can span multiple data files in some tablespaces
• E. A segment's blocks can be of different sizes
• F. A segment might have only one extent
• G. Segments can span multiple tablespaces

Correct answer: C, D, F

Explanation

The correct answers C, D, and F are valid because a smallfile tablespace can indeed be larger than a bigfile tablespace in certain configurations, segments can span multiple data files in specific tablespaces, and a segment can consist of just one extent. Options A and B are incorrect as they do not reflect the flexibility of tablespaces and extents, while E and G are also not correct since segments typically have uniform block sizes and cannot span multiple tablespaces.