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.
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)- B88% (23)
- C8% (2)
- E4% (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.
A tablespace is a logical structure scoped to a single Oracle database instance and cannot span or be shared across multiple databases.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.