🎴 Flashcard Mode
Oracle Database Administration
Card1 / 20
Mastered0
Review0
QuestionClick to flip
CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_01.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?
AnswerClick to flip back
A
Extent
💡 Explanation:
In a LOCALLY MANAGED tablespace with UNIFORM SIZE 1M, every EXTENT allocated within that tablespace is exactly 1 MB. This provides predictable space allocation and avoids fragmentation.