You work as a Database Administrator for your company. The company uses an Oracle database named OraBase. You use Recovery Manager (RMAN) for backup and recovery operations. You want to create a recovery catalog to store the metadata about the backup and recovery operations. You create a database named CatalogBase in which you will store the recovery catalog. You also create a database user account named CatOwner in the CatalogBase database, which will hold the tables and views constituting the recovery catalog. What else will you need to do in order to create the recovery catalog? Each correct answer represents a part of the solution. Choose all that apply.

Answer: A,B,D

Explanation: Answer options B, A, and D are correct. The RECOVERY_CATALOG_OWNER pre-defined role includes the privileges that allow the catalog owner to maintain and query the recovery catalog. Therefore, you will be required to grant the role to the CatOwner user account. After granting the role, you will be required to connect to the CatalogBase database by using the CatOwner user account. After connecting to the database, you can create the recovery catalog by executing the CREATE CATALOG command. Answer option C is incorrect. The SYSDBA system privilege is required for performing database administrative tasks, such as creating a database, altering a database, and starting up and shutting down an Oracle instance. You do not need to grant the SYSDBA system privilege to the CatOwner user account, as this user account will not be used to administer the database. The CatOwner user account will be used to only hold the catalog tables and views.