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 is fragmented with insufficient contiguous space, COALESCE merges adjacent free extents into larger ones. This creates the needed contiguous space. Cascade, constraint, and primary key options don't relate to space consolidation. Coalescing is the correct approach for import requirements.