nerdexam
Oracle

1Z0-034 · Question #131

Which three tasks can be performed using a duplicate database? (Choose three.)

The correct answer is A. Testing the backup and recovery procedures B. Testing the upgrade of an Oracle database to a new release C. Testing the effect of an application changes on database performance. See the full explanation below for the reasoning.

Question

Which three tasks can be performed using a duplicate database? (Choose three.)

Options

  • ATesting the backup and recovery procedures
  • BTesting the upgrade of an Oracle database to a new release
  • CTesting the effect of an application changes on database performance
  • DContinuously updating archive log files from the target database to support failover

How the community answered

(33 responses)
  • A
    85% (28)
  • D
    15% (5)

Community Discussion

8
Bao N.Bao N.Dec 21, 2025

A, B, and C are your three correct picks here. A duplicate database is essentially a copy of your production target that you spin up separately, so it is the perfect sandbox for testing backup and recovery procedures without touching live data, validating what an upgrade path actually does to your environment before you commit, and benchmarking how an application change hits performance under realistic conditions. Option D is the trap, because continuously shipping archive logs to support failover is what a standby database does in a Data Guard setup, not a duplicate. Keep that distinction straight because the exam loves to blur duplicate versus standby, and if your score is dipping on RMAN questions this is usually one of the spots bleeding points.

11
Brenda K.Brenda K.Dec 22, 2025

The duplicate-versus-standby trap is exactly where people bleed time too, so flag D fast and bank those seconds for the RMAN syntax questions later in the exam.

0
Brenda K.Brenda K.Jan 1, 2026

Saw this exact question on my 1Z0-034 sitting and knocked it out in under 40 seconds because D is a Data Guard standby job, not a duplicate database job, so I crossed it off immediately and banked the time. A, B, and C are your three keepers, this is a quick win so grab it and move on.

5
Lena V.Lena V.Jan 1, 2026

Solid elimination strategy, and worth adding that the exam will also test you on DUPLICATE DATABASE FOR STANDBY specifically, so knowing that syntax exists keeps you from second-guessing yourself when a question blurs that line on purpose.

0
Carlos M.Carlos M.Jan 7, 2026

A, B, C. D trips people up because it sounds plausible but that describes a physical standby database in a Data Guard setup, not a duplicate. RMAN duplicate gives you a point-in-time copy of the target for testing, it has no built-in mechanism to keep pulling archive logs from production on an ongoing basis for failover purposes. A duplicate is a sandbox, basically, so anything you would want to test without touching production fits right in, backup and recovery scripts, upgrade paths, and application load testing for performance impacts. I saw this exact question on my exam last month and the key word that knocked out D for me was "continuously," because nothing about RMAN duplicate implies a live, sustained connection to the target for log shipping.

4
Anjali D.Anjali D.Dec 28, 2025

Saw this exact question, eliminated D fast since that is standby database territory, locked in A, B, C.

2
Lena V.Lena V.Jan 10, 2026

I went back and forth on this one but I keep landing on A, B, and D as my three. The continuously updating archive logs piece is exactly what a duplicate database does when you set it up as a warm standby scenario, and Oracle's own RMAN duplicate documentation covers that use case directly. You use the duplicate to receive and apply those archived logs from the target so you have a near-real-time copy ready for failover, which is a core operational reason someone would build a duplicate in the first place. C feels like a distractor to me because performance testing against application changes is more of a snapshot clone or a refreshed test environment scenario, not the purpose Oracle specifically calls out for RMAN duplicate. The failover continuity angle in D is what separates a duplicate from just a plain backup restore, so I think that distinction is exactly what the exam is testing here.

-2
Carlos M.Carlos M.Jan 12, 2026

Good breakdown overall, Lena, but D actually belongs to Data Guard territory since failover continuity as an ongoing mechanism is what Active Data Guard handles, while C is correct because RMAN duplicate is genuinely recommended for creating a separate copy to performance test application changes without touching production. So the three are A, B, and C.

0
Full 1Z0-034 Practice