1Z0-083 · Question #2
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…
The correct answer is D. 2, 4, 5. https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CREATE- CATALOG.html#GUID-9CFE47C7-2273-48C4-8056-6A4042AF3CDC Example 2-70 Creating a Recovery Catalog and Registering a Database Assume that you start SQL*Plus and connect to the recovery catalog catdb with…
Question
Options
- A2, 4, 5, 6
- B1, 2, 3, 4, 5, 6
- C1, 2, 4, 5
- D2, 4, 5
- E1, 3, 4, 5
How the community answered
(28 responses)- A11% (3)
- B4% (1)
- D82% (23)
- E4% (1)
Explanation
https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CREATE- CATALOG.html#GUID-9CFE47C7-2273-48C4-8056-6A4042AF3CDC Example 2-70 Creating a Recovery Catalog and Registering a Database Assume that you start SQL*Plus and connect to the recovery catalog catdb with administrator privileges. You execute the CREATE USER statement as follows, replacing password with a user-specified password (see Oracle Database Security Guide for information on creating secure passwords). The SQL statement creates a user rco in database catdb and grant the rco user the RECOVERY_CATALOG_OWNER role. SQL> CREATE USER rco IDENTIFIED BY password 2 DEFAULT TABLESPACE cattbs 3 QUOTA UNLIMITED ON cattbs; SQL> GRANT recovery_catalog_owner TO rco;
Topics
Community Discussion
No community discussion yet for this question.