1Z0-062 · Question #166
Which two statements are true about extents?
The correct answer is B. Data blocks in an extent are logically contiguous but can be non-contiguous on disk. C. The blocks of a newly allocated extent, although free, may have been used before. An extent is a contiguous set of logically numbered data blocks within a single data file, and blocks in a newly allocated extent may have been used by prior objects before being freed.
Question
Which two statements are true about extents?
Options
- ABlocks belonging to an extent can be spread across multiple data files.
- BData blocks in an extent are logically contiguous but can be non-contiguous on disk.
- CThe blocks of a newly allocated extent, although free, may have been used before.
- DData blocks in an extent are automatically reclaimed for use by other objects in a tablespaee
How the community answered
(47 responses)- A4% (2)
- B87% (41)
- D9% (4)
Why each option
An extent is a contiguous set of logically numbered data blocks within a single data file, and blocks in a newly allocated extent may have been used by prior objects before being freed.
An extent must reside entirely within a single data file because it is defined as a contiguous range of block addresses within one file; blocks cannot span across multiple data files.
Data blocks within an extent are assigned logically contiguous block numbers within a single data file, meaning Oracle treats them as a sequential range; however, the underlying storage layer may not place those blocks as physically contiguous sectors on disk.
When Oracle allocates an extent from a tablespace's free space, that space may have previously belonged to a dropped or truncated segment, so the blocks - while marked free - can still contain data written by a prior object.
Blocks in an extent are not automatically reclaimed for other objects; they remain allocated to the owning segment until the segment is explicitly dropped, truncated, or the extent is manually deallocated.
Concept tested: Oracle extent structure and block allocation behavior
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/logical-storage-structures.html
Topics
Community Discussion
No community discussion yet for this question.