1Z0-060 Question #215: Real Exam Question with Answer & Explanation

Question

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

Explanation

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.

Common mistakes.

• B. 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.
• C. 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.
• D. 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.
• E. 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

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

No community discussion yet for this question.