Multiple choice technology databases

The utility used to rearrange the space in the tables is

  1. Reorg

  2. Runstats

  3. Rebinds

  4. Load

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

Database tables can become fragmented over time due to insertions, updates, and deletions, leading to inefficient storage and degraded performance. The REORG utility reorganizes table data to eliminate fragmentation and reclaim wasted space. Runstats updates statistics for the optimizer, Rebinds recompiles packages, and Load is for bulk data insertion - none of these directly address space fragmentation. REORG is specifically designed to restructure table storage for optimal space utilization and performance, making it the correct answer for space rearrangement.