nerdexam
Oracle

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.

Managing Database Storage Structures

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)
  • A
    85% (22)
  • B
    8% (2)
  • D
    4% (1)
  • E
    4% (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.

AAn extent cannot spread across data files.Correct

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.

BA segment cannot spread across data files.

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.

CA data file can belong to only one tablespace.Correct

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.

DA data file can have only one segment created in it.

A single data file can hold extents from many different segments - tables, indexes, LOBs, and others - so this statement is false.

EA data block can spread across multiple data files as it can consist of multiple operating system (OS)

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

#extent#segment#data file#tablespace relationship

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice