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.
Question
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)- A94% (47)
- C2% (1)
- D4% (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.
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.
This order (Extents, OS Blocks, Tablespace, Segments, Oracle Data Block) is entirely incorrect and reverses several relationships, such as placing Extents before OS Blocks.
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.
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
Community Discussion
No community discussion yet for this question.