1Z0-052 · Question #14
Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)
The correct answer is A. An extent cannot spread across data files. C. A data file can belong to only one tablespace. In Oracle's storage hierarchy, extents are confined to a single data file and each data file belongs to exactly one tablespace.
Question
Which two statements correctly describe the relation between a data file and the logical database structures? (Choose two)
Options
- AAn extent cannot spread across data files.
- BA segment cannot spread across data files.
- CA data file can belong to only one tablespace.
- DA data file can have only one segment created in it.
- EA data block can spread across multiple data files as it can consist of multiple operating system (OS)
How the community answered
(26 responses)- A85% (22)
- B8% (2)
- D4% (1)
- E4% (1)
Why each option
In Oracle's storage hierarchy, extents are confined to a single data file and each data file belongs to exactly one tablespace.
An extent is a contiguous set of Oracle data blocks allocated within a single data file; it cannot straddle two data files because block addresses are file-relative and contiguous allocation is enforced per-file.
A segment can span multiple data files as long as all those files belong to the same tablespace; each individual extent within the segment is confined to one file, but the segment as a whole is not restricted to a single file.
A data file is permanently associated with exactly one tablespace at creation time and cannot be shared between or reassigned to another tablespace without being re-created.
A single data file can hold extents from many different segments - tables, indexes, LOBs, and others - so this statement is false.
A data block is the smallest unit of I/O in Oracle and is entirely contained within a single data file; it cannot span OS blocks from different files.
Concept tested: Oracle logical vs physical storage structure relationships
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.