Oracle
1Z0-082 · Question #46
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.
Manage Tablespaces and Datafiles
Question
Which statement is true about smallfile tablespaces?
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
(53 responses)- A2% (1)
- B6% (3)
- C9% (5)
- D2% (1)
- E81% (43)
Topics
#smallfile tablespace#data files#segment spanning#locally managed
Community Discussion
No community discussion yet for this question.