Oracle Exam 1Z0-083 Topic 8 Question 104 Discussion

Actual exam question for Oracle's 1Z0-083 exam

Question #: 104
Topic #: 8

RMAN is connected to the target database prod1 and an auxiliary instance in nomount state. Examine the command to create a duplicate database: RMAN> DUPLICATE TARGET DATABASE TO dup1 FROM ACTIVE DATABASE NOFILENAMECHECK PASSWORD FILE SPFILE; Which two statements are true about the execution of the duplicate command?

AAll archive redo log files are automatically copied to the duplicate database.

BThe duplicate database has the same directory structure as the source database.

CThe duplicate database is created by using the backups created during the execution of

Dhe duplicate command.

EThe password file and SPFILE for the duplicate database dup1 are created in their respective default locations.

FThe duplicate database is created without using RMAN backups and prod1 is allowed to remain open during duplication.

Show Suggested Answer

Suggested Answer: A, D, E

by Nichelle at Sep 15, 2024, 09:32 AM

Limited Time Offer

25%

Off

Get Premium 1Z0-083 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Chandra

10 hours ago

Option A is incorrect, as the command states that it's connected to an auxiliary instance in nomount state, so the archive redo log files won't be automatically copied.

upvoted 0 times

...

Truman

21 days ago

I think options B and E are correct. The duplicate database will have the same directory structure as the source, and the password file and SPFILE will be created in their default locations.

upvoted 0 times

Gail

9 hours ago

I agree, the duplicate database will have the same directory structure as the source.

upvoted 0 times

...

Vallie

24 days ago

I'm not sure about option F. It seems risky to create a duplicate database without using RMAN backups.

upvoted 0 times

...

Thersa

25 days ago

I agree with Rikki. Option E is also true because password file and SPFILE are created in default locations.

upvoted 0 times

...

Rikki

27 days ago

I think option A is true because all archive redo log files are needed for the duplicate database.

upvoted 0 times

...