Exam 1z0-053 topic 3 question 25 discussion

Actual exam question from Oracle's 1z0-053

Question #: 25
Topic #: 3

[All 1z0-053 Questions]

Which option is best practice for creating a recovery catalog owner in the catalog database?

A. Granting UNLIMITED QUOTA on the SYSTEM tablespace to the owner
B. Allocating the SYSTEM tablespace as the default tablespace and granting the SYSDBA privilege to the user
C. Creating a new tablespace, allocating this as the default, and granting UNLIMITED QUOTA on this tablespace to the user
D. Allocating the SYSAUX tablespace as the default tablespace and granting UNLIMITED QUOTA on this tablespace to the user

Show Suggested Answer

Suggested Answer: C 🗳️
To create the recovery catalog schema in the recovery catalog database:
1. Start SQL*Plus and connect with administrator privileges to the database containing the recovery catalog. In this example, the database is catdb.
2. Create a user and schema for the recovery catalog. For example, you could enter the following SQL statement (replacing password with a user-defined password):
CREATE USER rman IDENTIFIED BY password

TEMPORARY TABLESPACE temp -

DEFAULT TABLESPACE tools -
QUOTA UNLIMITED ON tools;
3. Grant the RECOVERY_CATALOG_OWNER role to the schema owner. This role provides the user with all privileges required to maintain and query the recovery catalog.
GRANT RECOVERY_CATALOG_OWNER TO rman;

by thuthuysphn58 at April 4, 2025, 7:47 a.m.

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!