Which utility is used to reclaim fragmented space

  1. LOAD

  2. UNLOAD

  3. REORG

  4. RUNSTATS


Correct Option: C

AI Explanation

To answer this question, you need to understand the concept of fragmented space and the utility used to reclaim it.

Fragmented space refers to the scattered or unused space within a database or storage system. This can occur when records or data are deleted or modified, leaving gaps or unused space. Reclaiming fragmented space involves consolidating or rearranging the data to optimize the storage.

The utility used to reclaim fragmented space is the REORG utility.

Option A) LOAD - The LOAD utility is used to load data into a database. It does not specifically address the reclamation of fragmented space.

Option B) UNLOAD - The UNLOAD utility is used to extract data from a database. It does not address the reclamation of fragmented space.

Option C) REORG - The REORG utility is used to reorganize data in a database, including the reclamation of fragmented space. This utility helps to improve performance and optimize storage.

Option D) RUNSTATS - The RUNSTATS utility is used to collect statistics about the data in a database. It does not specifically address the reclamation of fragmented space.

The correct answer is C) REORG. This option is correct because the REORG utility is used to reclaim fragmented space by reorganizing and optimizing the data in a database.

Find more quizzes: