Oracle Database Administration II — Question 66

Examine these actions:
1. Create a new database for a recovery catalog.
2. Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3. Configure ARCHIVELOG mode for the catalog database.
4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog.
5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.
6. Grant the SYSBACKUP privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

Answer options

• A. 2, 4, 5, 6
• B. 1, 2, 3, 4, 5, 6
• C. 1, 2, 4, 5
• D. 2, 4, 5
• E. 1, 3, 4, 5

Correct answer: D

Explanation

The minimum actions required before executing the CREATE CATALOG command are to create a tablespace for the recovery catalog and establish a user to own the schema, along with granting necessary roles. Actions 5 and 6 are also essential, but actions 1 and 3 are not mandatory at this stage, making option D the correct choice.