nerdexam
Oracle

1Z0-060 · Question #215

Which statement is true concerning compression during an Online Datafile Move?

The correct answer is A. Only tables may be compressed during the Online Datafile Move. During an Oracle Online Datafile Move, compression can only be applied to table segments, not to indexes or other object types residing in the datafile.

New Features for Storage

Question

Which statement is true concerning compression during an Online Datafile Move?

Options

  • AOnly tables may be compressed during the Online Datafile Move.
  • BThe DBA may choose which objects in the datafile to be moved get compressed.
  • CAll objects in a data file to be moved will always to be compressed.
  • DUncompressed data files may be moved online to compress the entire file with Hybrid Columnar
  • EIf an object is already compressed in the source location, then the compression type for that object

How the community answered

(47 responses)
  • A
    81% (38)
  • B
    6% (3)
  • C
    11% (5)
  • E
    2% (1)

Why each option

During an Oracle Online Datafile Move, compression can only be applied to table segments, not to indexes or other object types residing in the datafile.

AOnly tables may be compressed during the Online Datafile Move.Correct

When Oracle performs an Online Datafile Move, any compression operation applies exclusively to table segments. Index segments and other object types within the datafile are not eligible to have their compression changed during the move operation, making this the accurate scope of compression behavior for this feature.

BThe DBA may choose which objects in the datafile to be moved get compressed.

The DBA cannot selectively choose which individual objects within the datafile get compressed; compression eligibility during an Online Datafile Move is determined by object type, not by DBA selection.

CAll objects in a data file to be moved will always to be compressed.

Compression is not automatically and universally applied to all objects in a datafile during an Online Datafile Move; it is limited to table segments and is not a mandatory outcome of the move.

DUncompressed data files may be moved online to compress the entire file with Hybrid Columnar

Hybrid Columnar Compression is not applied as a blanket compression to an entire datafile during an Online Datafile Move; HCC applies at the segment level and requires specific Exadata or compatible storage.

EIf an object is already compressed in the source location, then the compression type for that object

An object's existing compression type is not necessarily carried over unchanged; the compression outcome depends on the target tablespace settings and the parameters of the move operation.

Concept tested: Compression scope during Oracle Online Datafile Move

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-data-files-and-temp-files.html

Topics

#online datafile move#HCC compression#datafile compression#in-place compression

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice