nerdexam
Oracle

1Z0-052 · Question #172

Note the following structures in your database server: 1. Extents 2. OS Blocks 3. Tablespace 4. Segments 5. Oracle Data Block Which option has the correct arrangement of these structures from the…

The correct answer is A. 2, 5, 1, 4, 3. Oracle's logical and physical storage structures form a strict hierarchy from smallest to largest: OS Blocks, Oracle Data Blocks, Extents, Segments, and Tablespaces.

Managing Database Storage Structures

Question

Note the following structures in your database server: 1. Extents 2. OS Blocks 3. Tablespace 4. Segments 5. Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest?

Options

  • A2, 5, 1, 4, 3
  • B1, 2, 3, 4, 5
  • C5, 2, 1, 3, 4
  • D2, 1, 5, 4, 3

How the community answered

(50 responses)
  • A
    94% (47)
  • C
    2% (1)
  • D
    4% (2)

Why each option

Oracle's logical and physical storage structures form a strict hierarchy from smallest to largest: OS Blocks, Oracle Data Blocks, Extents, Segments, and Tablespaces.

A2, 5, 1, 4, 3Correct

The correct order is: OS Blocks (2) are the smallest physical unit, Oracle Data Blocks (5) are built on top of one or more OS blocks, Extents (1) are contiguous sets of Oracle data blocks, Segments (4) are collections of extents, and Tablespaces (3) are the largest logical unit containing one or more segments.

B1, 2, 3, 4, 5

This order (Extents, OS Blocks, Tablespace, Segments, Oracle Data Block) is entirely incorrect and reverses several relationships, such as placing Extents before OS Blocks.

C5, 2, 1, 3, 4

This order places Oracle Data Block before OS Blocks, which is incorrect because an Oracle Data Block is composed of one or more OS blocks, making it larger.

D2, 1, 5, 4, 3

This order (OS Blocks, Extents, Oracle Data Block, Segments, Tablespace) incorrectly places Extents before Oracle Data Blocks, when in fact Extents are groups of contiguous Oracle Data Blocks and are therefore larger.

Concept tested: Oracle database logical and physical storage hierarchy

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

Topics

#storage hierarchy#data blocks#extents#segments and tablespaces

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice