To answer this question, you need to understand the purpose of each utility in DB2.
Option A) QUIESCE - This option is incorrect because the QUIESCE utility is used to temporarily halt the activity on a database or tablespace, allowing for maintenance operations to be performed. It does not restore tablespaces and indexes to a specific instance.
Option B) RECOVER - This option is correct. The RECOVER utility is used to restore and recover tablespaces and indexes in DB2. It allows you to restore data from a backup to a specific instance, ensuring data consistency and integrity.
Option C) REORG - This option is incorrect. The REORG utility is used to reorganize DB2 objects, such as tables and indexes, to improve performance and reclaim space. It does not restore tablespaces and indexes to a specific instance.
Option D) RUNSTATS - This option is incorrect. The RUNSTATS utility is used to collect statistics about DB2 objects, such as tables and indexes, to help the query optimizer make efficient execution plans. It does not restore tablespaces and indexes to a specific instance.
The correct answer is B) RECOVER. This option is correct because the RECOVER utility is specifically designed to restore and recover tablespaces and indexes in DB2.