nerdexam
Oracle

1Z0-052 · Question #15

Which two statements are true regarding a tablespace? (Choose two.)

The correct answer is B. It can consist of multiple data files D. It can contains segments of different sizes. A tablespace is a logical storage unit that can be composed of multiple data files and can hold segments of varying sizes.

Managing Database Storage Structures

Question

Which two statements are true regarding a tablespace? (Choose two.)

Options

  • AIt can span multiple databases
  • BIt can consist of multiple data files
  • CIt can contain blocks of different files
  • DIt can contains segments of different sizes
  • EIt can contains a part of nonpartitioned segment

How the community answered

(26 responses)
  • B
    88% (23)
  • C
    8% (2)
  • E
    4% (1)

Why each option

A tablespace is a logical storage unit that can be composed of multiple data files and can hold segments of varying sizes.

AIt can span multiple databases

A tablespace is a logical structure scoped to a single Oracle database instance and cannot span or be shared across multiple databases.

BIt can consist of multiple data filesCorrect

A tablespace can have one or more data files added to it via ALTER TABLESPACE ADD DATAFILE, allowing it to grow beyond the size limits of a single file.

CIt can contain blocks of different files

While a tablespace can reference blocks from multiple data files, blocks within a tablespace are all the same size (DB_BLOCK_SIZE) - the phrasing implies variable block sizes across files, which Oracle does not support at the tablespace level.

DIt can contains segments of different sizesCorrect

A tablespace can contain segments of different sizes - for example, a small lookup table segment and a large fact table segment can coexist in the same tablespace, each occupying a different amount of space.

EIt can contains a part of nonpartitioned segment

A nonpartitioned segment must reside entirely within a single tablespace; a tablespace cannot contain only a partial nonpartitioned segment, because the entire segment is assigned to one tablespace.

Concept tested: Oracle tablespace structure and segment storage rules

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

Topics

#tablespace#data files#segments#tablespace structure

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice