Which utility should be used for maintaining consistency for list of tablespaces

  1. QUIESCE

  2. CHECK

  3. REORG

  4. RUNSTATS


Correct Option: A

AI Explanation

To maintain consistency for a list of tablespaces, the utility that should be used is QUIESCE.

Option A) QUIESCE - This option is correct because the QUIESCE utility is used to temporarily disable updates to a tablespace. It ensures that no changes are made to the data during maintenance operations, thus maintaining consistency.

Option B) CHECK - This option is incorrect because the CHECK utility is used to perform integrity checks on table data, but it does not specifically maintain consistency for tablespaces.

Option C) REORG - This option is incorrect because the REORG utility is used to reorganize table data and indexes, which can improve performance and reclaim space. While it can contribute to maintaining consistency indirectly, it is not the primary utility for this purpose.

Option D) RUNSTATS - This option is incorrect because the RUNSTATS utility is used to collect statistics about the data in a table or index, which helps the database optimizer make informed decisions about query execution. It does not directly maintain consistency for tablespaces.

The correct answer is A) QUIESCE. This option is correct because the QUIESCE utility is specifically designed to maintain consistency for a list of tablespaces by temporarily disabling updates.

Find more quizzes: