1Z0-062 · Question #233
You execute this command: Which two statements are true about segment space management for segments in thistablespace?
The correct answer is A. Space utilization inside segments is mapped by bitmaps. D. The PCTUSED storageparameter has no effect on segments created in this tablespace. For tablespaces using automatic segment space management, space utilization within segments is managed by bitmaps and the PCTUSED storage parameter is ignored.
Question
You execute this command:
Which two statements are true about segment space management for segments in thistablespace?
Options
- ASpace utilization inside segments is mapped by bitmaps.
- BSegments are automatically shrunk and compressed when rows are deleted.
- CThe PCTFREE storage parameter has no effect on segments created in this tablespace.
- DThe PCTUSED storageparameter has no effect on segments created in this tablespace.
How the community answered
(21 responses)- A76% (16)
- B10% (2)
- C14% (3)
Why each option
For tablespaces using automatic segment space management, space utilization within segments is managed by bitmaps and the PCTUSED storage parameter is ignored.
Automatic segment space management (ASSM) uses bitmaps to track free and used space within data blocks and segments, optimizing space allocation and deallocation.
Automatic shrinking and compression are separate features (e.g., ALTER TABLE ... SHRINK SPACE, Advanced Row Compression) and are not an inherent behavior of SEGMENT SPACE MANAGEMENT AUTO upon row deletion.
The PCTFREE parameter, which reserves space in a block for future updates to existing rows, still applies to segments in an ASSM tablespace.
When a tablespace is created with SEGMENT SPACE MANAGEMENT AUTO, Oracle automatically manages free space, rendering the PCTUSED parameter irrelevant for block eligibility.
Concept tested: Oracle Automatic Segment Space Management
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/CREATE-TABLESPACE.html#GUID-EFC91E47-0B0B-4811-9F2F-01BF9E488C94
Topics
Community Discussion
No community discussion yet for this question.