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 spaces, which helps avoid row migration during import by ensuring sufficient contiguous space. Options A, B, and C are export/import parameters that don't prevent migration.

Keep practicing — related questions