Multiple choice

What should be done to import data and to avoid migration?

  1. Use the CASCADE option during import

  2. Use the COMPRESS option during export

  3. Use the RECORDLENGTH option during export

  4. Coalesce free space
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Coalescing free space combines adjacent free extents into larger contiguous free spaces before importing data. This prevents data migration during the import process because the importer can place data in larger, contiguous free areas rather than scattering it and causing fragmentation. CASCADE is for dependencies, COMPRESS affects export format, and RECORDLENGTH is for I/O efficiency - none address migration prevention.

Keep practicing — related questions