exam questions

Exam 1z0-083 All Questions

View all questions & answers for the 1z0-083 exam

Exam 1z0-083 topic 1 question 54 discussion

Actual exam question from Oracle's 1z0-083
Question #: 54
Topic #: 1
[All 1z0-083 Questions]

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?

  • 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
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Apollo5
Highly Voted 4 years, 6 months ago
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
upvoted 18 times
...
Guhborges
Most Recent 1 year, 6 months ago
Selected Answer: D
2-4-5 letter D is Right. 1 is wrong, cause you don't necessary need a new database to be the catalog. :)
upvoted 1 times
...
_gio_
1 year, 8 months ago
Selected Answer: D
I agree with Apollo5. Recovery catalog is a schema that can be contained in any existing DB
upvoted 1 times
...
ScottL
1 year, 9 months ago
Selected Answer: D
D - see Apollo5
upvoted 1 times
...
vkra
1 year, 11 months ago
Selected Answer: C
I would say C too
upvoted 1 times
...
Nonicknameavailable
1 year, 11 months ago
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.
upvoted 2 times
auwia
7 months, 1 week ago
The problem is saying "create a new database", to be correct your sentence it should be "create a database" --> not new
upvoted 1 times
...
...
senator
3 years, 3 months ago
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
upvoted 2 times
...
smartvan
3 years, 3 months ago
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
upvoted 2 times
...
niabs
3 years, 6 months ago
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
upvoted 2 times
freemun05
2 years, 10 months ago
question is specific - "minimum actions" D is correct
upvoted 1 times
...
...
Rogazan
3 years, 8 months ago
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!
upvoted 4 times
...
Jatindra
3 years, 10 months ago
Correct Ans: D
upvoted 2 times
...
asefa
3 years, 11 months ago
D is the minimum actions that must be performed before executing create catalog command
upvoted 4 times
...
pgtips
4 years, 5 months ago
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.
upvoted 2 times
SimoneF
3 years, 9 months ago
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.
upvoted 1 times
...
...
janw
4 years, 5 months ago
agree with d, only 4&5 really required.
upvoted 3 times
...
julica
4 years, 6 months ago
Oly D is correct am minimal steps.
upvoted 2 times
...
klever35
4 years, 7 months ago
Correct Answer E
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago