Which utility is used to update the data related to tablespaces & indexes in system catalog tables

  1. LOAD

  2. UNLOAD

  3. REORG

  4. RUNSTATS


Correct Option: D

AI Explanation

To answer this question, you need to understand the utilities used to update data related to tablespaces and indexes in system catalog tables.

Option A) LOAD - The LOAD utility is used to load data into a table from an input file, but it does not update data related to tablespaces and indexes in system catalog tables.

Option B) UNLOAD - The UNLOAD utility is used to unload data from a table into an output file, but it does not update data related to tablespaces and indexes in system catalog tables.

Option C) REORG - The REORG utility is used to reorganize the data and indexes of a table to improve performance, but it does not update data related to tablespaces and indexes in system catalog tables.

Option D) RUNSTATS - The correct answer is D. The RUNSTATS utility is used to update the statistics of tables and indexes in system catalog tables. These statistics are used by the query optimizer to generate efficient access plans for SQL queries.

Therefore, the correct answer is D) RUNSTATS.

Find more quizzes: