nerdexam
Oracle

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.

Managing Database Storage Structures

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)
  • A
    4% (2)
  • B
    87% (41)
  • D
    9% (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.

ABlocks belonging to an extent can be spread across multiple data files.

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.

BData blocks in an extent are logically contiguous but can be non-contiguous on disk.Correct

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.

CThe blocks of a newly allocated extent, although free, may have been used before.Correct

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.

DData blocks in an extent are automatically reclaimed for use by other objects in a tablespaee

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

#Extents#Data blocks#Storage structures#Logical vs physical contiguity

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice