Exam 1z0-083 All QuestionsBrowse all questions from this exam
Go to Exam
Question 54

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?

    Correct Answer: C

    To execute the CREATE CATALOG command, you must first create a database to store the recovery catalog (step 1). Then, you create a tablespace with sufficient space for the catalog (step 2). You also need to create a user who will own the recovery catalog schema and assign quota on the created tablespace (step 4). Finally, you must grant the RECOVERY_CATALOG_OWNER role to this user (step 5). Configuring ARCHIVELOG mode and granting the SYSBACKUP privilege are not necessary steps for creating the catalog. Therefore, the minimum actions required are steps 1, 2, 4, and 5.

Discussion
Apollo5Option: D

D is the right answer. Step No 2 is required, so it must be contained in the choise Step 1 is optional Step 3 is not necessary Steps 4 & 5 are required Step 6 is not necessary

RogazanOption: C

I agree with option D (minimum of actions), but if Oracle asks me in the exam, I will answer that the correct option is C. This confirms that we know that the Catalog Database must be a different one which we want to protect!

asefaOption: D

D is the minimum actions that must be performed before executing create catalog command

janwOption: D

agree with d, only 4&5 really required.

NonicknameavailableOption: C

Correct answer is C. The question gives a sequence of steps and asks you to examine the minimum options in that sequence. It does not tell you a database already exists.

auwia

The problem is saying "create a new database", to be correct your sentence it should be "create a database" --> not new

senatorOption: D

D is the correct answer when reading both 12c and 19c oracle docs. https://docs.oracle.com/en/database/oracle/oracle-database/19/rcmrf/CREATE-CATALOG.html#GUID-9CFE47C7-2273-48C4-8056-6A4042AF3CDC Examples 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; SQL> EXIT

smartvanOption: D

This is all you need to create the catalog. tested SQL> CREATE USER restoretests IDENTIFIED BY oracle >>>>>> create user(4) DEFAULT TABLESPACE tools >>>>>>>>>> create tablespace (2) TEMPORARY TABLESPACE temp QUOTA UNLIMITED ON tools; SQL> GRANT CONNECT, RECOVERY_CATALOG_OWNER TO <username>; >>> grant privilege (5) $ rman target / catalog <rcat1-rman_user>/<rcat1-password>@<catalog_tns> (instance name) select instance_name from v$instance; RMAN> create catalog; correct answer is D

niabsOption: C

I will choose C Because likely you will create a dedicated database for the catalog unless you already have a separated one, which is not mentioned here

freemun05

question is specific - "minimum actions" D is correct

JatindraOption: D

Correct Ans: D

pgtipsOption: E

I believe, E, as the Option 1: Create a new Database is one of the Choice I go for E. If it was not there then probably D makes more sense.

SimoneF

1 is disputable but I assume they imply you do have a DB, and you should create another one. In that case, it's not necessary to simply give the command, even though you wouldn't create a catalog on a database which is not dedicated. Besides, 3 - Enabling archivelog mode on the catalog database - is not necessary to create a catalog.

julicaOption: D

Oly D is correct am minimal steps.

GuhborgesOption: D

2-4-5 letter D is Right. 1 is wrong, cause you don't necessary need a new database to be the catalog. :)

_gio_Option: D

I agree with Apollo5. Recovery catalog is a schema that can be contained in any existing DB

ScottLOption: D

D - see Apollo5

vkraOption: C

I would say C too

klever35Option: E

Correct Answer E