Multiple choice

A table is being imported and it must be ensured that the table is put into a single contiguous area. There is not a single contiguous area large enough for the entire space allocated to the table. What should be done to achieve this?

  1. Use the cascade option.

  2. Use the constraint option.

  3. Use the primary key option.

  4. Coalesce the tablespace the table is using.

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When a tablespace becomes fragmented with non-contiguous free space, using COALESCE merges adjacent free extents into larger contiguous extents. This is necessary when importing requires more contiguous space than any single free extent can provide.