1Z0-052 · Question #242
You are creating a locally managed tablespace to meet the following requirements: All the extents should be of the same size. The data should be spread across two data files. A bitmap should be used…
The correct answer is B. specify extent allocation as Uniform E. create the tablespace as smallfile tablespace F. set segment space management to Automatic. Meeting these tablespace requirements calls for Uniform extent allocation, a smallfile tablespace (to allow multiple data files), and Automatic segment space management (which uses bitmaps for free space tracking).
Question
You are creating a locally managed tablespace to meet the following requirements:
All the extents should be of the same size. The data should be spread across two data files. A bitmap should be used to record the free space within the allocated extents. Which three options would you choose? (Choose three.)
Options
- Aset PCTFREE and PCTUSED to 50
- Bspecify extent allocation as Uniform
- Cspecify extent allocation as Automatic
- Dcreate the tablespace as bigfile tablespace
- Ecreate the tablespace as smallfile tablespace
- Fset segment space management to Automatic
- Guse the RESIZE clause while creating the tablespace
How the community answered
(45 responses)- A4% (2)
- B84% (38)
- D2% (1)
- G9% (4)
Why each option
Meeting these tablespace requirements calls for Uniform extent allocation, a smallfile tablespace (to allow multiple data files), and Automatic segment space management (which uses bitmaps for free space tracking).
PCTFREE and PCTUSED are parameters for manual segment space management and are irrelevant when Automatic segment space management is used.
Specifying Uniform extent allocation ensures all extents are allocated at the same fixed size, directly satisfying the requirement that all extents be the same size.
Automatic extent allocation (AUTOALLOCATE) allows Oracle to vary extent sizes as needed, which violates the requirement that all extents be the same size.
A bigfile tablespace supports only a single data file, which makes it impossible to spread data across two data files as required.
A smallfile tablespace supports multiple data files, allowing the data to be spread across two data files as required; a bigfile tablespace is limited to exactly one data file.
Setting segment space management to Automatic causes Oracle to use bitmaps within each segment to record free space within allocated extents, satisfying the bitmap free-space tracking requirement.
The RESIZE clause is used to change the size of an existing data file after creation and is not relevant to tablespace creation requirements.
Concept tested: Locally managed tablespace configuration with Uniform extents and ASSM
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-tablespaces.html
Topics
Community Discussion
No community discussion yet for this question.