Oracle
1Z0-082 · Question #55
Which three statements are true concerning logical and physical database structures? (Choose three.)
The correct answer is C. A smallfile tablespace might be bigger than a bigfile tablespace F. A segment might have only one extent G. Segments can span multiple tablespaces. See the full explanation below for the reasoning.
Storage Structures
Question
Which three statements are true concerning logical and physical database structures? (Choose three.)
Options
- AAll tablespaces may have one or more data files
- BThe extents of a segment must always reside in the same datafile
- CA smallfile tablespace might be bigger than a bigfile tablespace
- DA segment can span multiple data files in some tablespaces
- EA segment's blocks can be of different sizes
- FA segment might have only one extent
- GSegments can span multiple tablespaces
How the community answered
(28 responses)- A14% (4)
- B4% (1)
- C71% (20)
- D4% (1)
- E7% (2)
Topics
#tablespaces#segments#extents#datafiles
Community Discussion
No community discussion yet for this question.