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

Roselle

27 days ago

I'm just hoping the exam doesn't ask me to duplicate my efforts. One duplicate is enough for me!

upvoted 0 times

Noble

4 days ago

I know, duplicating efforts can be exhausting!

upvoted 0 times

...

Stefanie

5 days ago

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

upvoted 0 times

...

Tawny

6 days ago

A) All archive redo log files are automatically copied to the duplicate database.

upvoted 0 times

...

Yuette

29 days ago

Option C is also correct. The duplicate database is created using the backups created during the execution of the duplicate command.

upvoted 0 times

...

Hildegarde

1 months ago

Option F is just ridiculous. How can you create a duplicate database without using RMAN backups and keeping the source database open? That's like trying to bake a cake without any ingredients!

upvoted 0 times

Keneth

9 days ago

Exactly, it's always best to follow best practices when creating duplicate databases to avoid any potential issues.

upvoted 0 times

...

Minna

15 days ago

Creating a duplicate database without RMAN backups would be risky and could lead to data corruption.

upvoted 0 times

...

Elly

16 days ago

Yes, using RMAN backups ensures that the duplicate database is consistent with the source database.

upvoted 0 times

...

Lemuel

17 days ago

I agree, option F doesn't make any sense. It's important to use RMAN backups for creating a duplicate database.

upvoted 0 times

...

Chandra

2 months 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

Lashaun

16 days 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

...

Ben

18 days ago

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

upvoted 0 times

...

Janine

25 days ago

B) The duplicate database has the same directory structure as the source database.

upvoted 0 times

...

Truman

2 months 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