1Z0-062 · Question #342
You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes. Which set of tablespace attributes can be specified for a tablespace that satifies the…
The correct answer is D. EXTENT MANAGEMENT LOCAL AUTOALLOCATE. The question asks how to create a locally managed tablespace capable of storing segments with different extent sizes. This requirement is met by using EXTENT MANAGEMENT LOCAL AUTOALLOCATE, which allows Oracle to automatically manage extent sizes.
Question
You want to create a locally managed tablespace called NEWTBS to store segments with different extent sizes. Which set of tablespace attributes can be specified for a tablespace that satifies the requirements?
Options
- AEXTENT MANAGEMENT LOCAL STORAGE (INITIAL 5M MAXSIZE 10M)
- BREUSE AUTOEXTEND ON MAXSIZE UNLIMITED
- CEXTENT MNAGMENT LOCAL SEGMENT SPACE MANAGEMENT UNIFORM
- DEXTENT MANAGEMENT LOCAL AUTOALLOCATE
How the community answered
(21 responses)- A14% (3)
- B5% (1)
- C5% (1)
- D76% (16)
Why each option
The question asks how to create a locally managed tablespace capable of storing segments with different extent sizes. This requirement is met by using EXTENT MANAGEMENT LOCAL AUTOALLOCATE, which allows Oracle to automatically manage extent sizes.
The `STORAGE` clause with `INITIAL` and `MAXSIZE` is used to define storage parameters for segments, but `MAXSIZE` is not an attribute of `EXTENT MANAGEMENT LOCAL` and this syntax is incorrect for defining extent management.
`REUSE AUTOEXTEND ON MAXSIZE UNLIMITED` are attributes related to data file management and sizing, not to the extent management strategy for a tablespace that allows for different extent sizes.
`EXTENT MANAGEMENT LOCAL UNIFORM` (or `SEGMENT SPACE MANAGEMENT UNIFORM`) would mean that all extents allocated within the tablespace will be of a fixed, uniform size, which contradicts the requirement for "different extent sizes."
Specifying `EXTENT MANAGEMENT LOCAL AUTOALLOCATE` for a tablespace instructs Oracle to automatically determine the optimal extent sizes when allocating space for segments. This allows for segments to have varying extent sizes without manual intervention, satisfying the requirement to store segments with different extent sizes.
Concept tested: Locally managed tablespace extent management
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TABLESPACE.html#GUID-E54E10B3-2F40-42E3-B225-86DEFB3264F6
Topics
Community Discussion
No community discussion yet for this question.