nerdexam
Oracle

1Z0-062 · Question #144

Which two statements are true about the logical storage structure of an Oracle database?

The correct answer is D. It is possible to have tablespaces of different block sizes. E. A data block is the smallest unit of I/O in data files. In Oracle's logical storage hierarchy, tablespaces can have different block sizes, and the data block is the smallest unit of I/O for data files.

Managing Database Storage Structures

Question

Which two statements are true about the logical storage structure of an Oracle database?

Options

  • AAn extent contains data blocks that are always physically contiguous on disk.
  • BAn extent can span multiple segments,
  • CEach data block always corresponds to one operating system block.
  • DIt is possible to have tablespaces of different block sizes.
  • EA data block is the smallest unit of I/O in data files.

How the community answered

(25 responses)
  • A
    4% (1)
  • C
    4% (1)
  • D
    92% (23)

Why each option

In Oracle's logical storage hierarchy, tablespaces can have different block sizes, and the data block is the smallest unit of I/O for data files.

AAn extent contains data blocks that are always physically contiguous on disk.

Extents are not guaranteed to be physically contiguous on disk; with features such as Oracle ASM striping or certain OS file systems, the blocks that make up an extent may reside at non-contiguous physical locations.

BAn extent can span multiple segments,

An extent is allocated exclusively to a single segment and cannot span multiple segments; each segment manages its own collection of extents independently.

CEach data block always corresponds to one operating system block.

An Oracle data block can span multiple OS blocks when DB_BLOCK_SIZE exceeds the OS block size - for example, an 8KB Oracle block on a file system with 4KB OS blocks occupies two OS blocks.

DIt is possible to have tablespaces of different block sizes.Correct

Oracle supports nonstandard block sizes at the tablespace level using the BLOCKSIZE clause; individual tablespaces can use block sizes (2K, 4K, 8K, 16K, 32K) that differ from the instance default set by DB_BLOCK_SIZE, enabling storage and performance tuning flexibility.

EA data block is the smallest unit of I/O in data files.Correct

The Oracle data block is the finest granularity at which the database engine reads from and writes to data files; all I/O operations on data files are performed in whole data block units, making it the fundamental I/O unit.

Concept tested: Oracle logical storage structure - blocks, extents, and tablespace block sizes

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/logical-storage-structures.html

Topics

#data blocks#extents#tablespaces#logical storage

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice