Upgrade Oracle DBA 11g to Oracle Database 12c — Question 41

You want to move your existing recovery catalog to another database.
Examine the steps:
1)Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the create catalog command.
4)Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
5)Import the source recovery catalog schema by using the import catalog command.
6)Connect to the destination database.
7) Connect as catalog to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.

Answer options

Correct answer: C

Explanation

The correct sequence to move the recovery catalog is C: 1, 2, 6, 4. First, you export the catalog data from the source database, then you create a user in the target database with the required privileges, connect to the destination database, and finally import the catalog data. Options A, B, and D include incorrect steps or sequences that do not align with the necessary process.