1Z0-072 · Question #10
Which statement is true about smallfile tablespaces?
The correct answer is E. Segments can span multiple data files. See the full explanation below for the reasoning.
Question
Options
- AExtent location metadata is stored in the data dictionary by default.
- BThe number of data files is constrained only by the size of the storage array.
- CMaximum file size can be set to unlimited only if the logical volume manager supports striping.
- DSegments can span multiple tablespaces.
- ESegments can span multiple data files.
How the community answered
(47 responses)- A9% (4)
- B4% (2)
- C15% (7)
- D2% (1)
- E70% (33)
Community Discussion
5
Mei-Ling H.Nov 24, 2025E is correct. In a smallfile tablespace, a single segment can have its extents spread across multiple data files that belong to that same tablespace, which is exactly how Oracle allocates space when one data file fills up. Watch out for D, because the word "tablespaces" makes it a trap, since a segment is always owned by exactly one tablespace, never multiple.
Hiroshi T.Dec 5, 2025E is right. B tempts but file count is limited by DB_FILES, not storage.
Grace U.Dec 6, 2025Right, and the trap is that storage feels like the natural bottleneck so your brain jumps to B, but the exam wants you to know DB_FILES is its own separate ceiling that can bite you long before you run out of space.
Grace U.Nov 29, 2025D flips files and tablespaces on you, go with E.
Mei-Ling H.Nov 30, 2025Agree, and worth noting: the reason D trips people is the word "drops" buried in the fine print, which sounds harmless until you realize it means your files are gone from the source too, not just moved.