Free 1z0-066: Oracle Database 12c Data Guard Administration Exam Questions and Answers

Last updated: September 12, 2026

Provider

Oracle

Questions in our bank

1000+

Free to read

First 10, with answers

Official page

Official Exam website

Our test mode duration & pass mark

130 mins · 70%

Verified answers

Reviewed weekly

Recommended: Switch to Test Mode to start a practice test that simulates the real exam experience.

1. Question #1

   You must propose an Oracle Data Guard configuration tor a database supporting an OLTP workload that meets these permanent requirements: 1. Data loss is not permitted. 2. Read-only applications should not connect to the primary database instance. Additionally, there are these requirements, only one of which is ever done at any one time: 3. It should be possible to apply and test designated patches with a minimum amount of downtime. 4. Upgrading to a new database release should be performed with the least possible amount of downtime. 5. New application software releases should be tested against an exact up-to-date replica of the production database. You propose a primary database with one physical standby database configured in Maximum Protection mode. Which requirements do you meet?

   • A. 2,3, 4, and 5
   • B. 1,2, 3,4, and 5
   • C. 1 and 2
   • D. only requirement 5
   Reveal Answer

2. Question #2

   You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands: What is true concerning this configuration?

   • A. The Close_by primary database instance forwards redo to the FSjnst Far Sync instance, which forwards the redo in turn to the Far_away physical standby
   • B. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection.
   • C. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FSjnst Far Sync instance.
   • D. The far sync instance will not forward redo to the Far_away physical standby because Fast-Stan: Failover is disabled
   Reveal Answer

3. Question #3

   Examine the Data Guard configuration; What can you conclude based on this error?

   • A. Cats is a snapshot standby database
   • B. The redo transport mode is set to ASYNC for the standby database Sheep
   • C. The redo transport mode is set to ASYNC for both standby databases
   • D. The redo transport mode is set to ASYNC for the standby database Cats
   Reveal Answer

4. Question #4

   You must configure an Oracle Data Guard environment consisting of: 1. A primary database 2. A Physical Standby Database 3. A Snapshot Standby Database You must meet these requirements: 1. Primary database availability should not be compromised by the availability of the standby databases. 2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on the primary database and on at least one standby database. Which redo transport mode, and which protection mode should you configure to meet these requirements?

   • A. SYNC AFFIRM and Maximum Protection
   • B. SYNC NOAFFIRM and Maximum Protection
   • C. SYNC AFFIRM and Maximum Availability
   • D. SYNC NOAFFIRM and Maximum Availability
   Reveal Answer

5. Question #5

   Examine the Data Guard configuration: DGMGRL> show configuration Configuration -Animals Protection Mode: MaxAvailability Databases: dogs- Primary database sheep- (*) Physical standby database cats- Physical standby database Fast-Start Failover: ENABLED Configuration Status: SUCCESS What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?

   • A. The switchover succeeds but Dogs need to be reinstated
   • B. The switchover succeeds but Fast-Start Failover is suspended.
   • C. The switchover succeeds and Cats become the new failover target.
   • D. The switchover succeeds and Dogs become the new failover target
   Reveal Answer

6. Question #6

   Examine this query and its output: Which are true?

   • A. The observer is not connected to the database on which the query was executed.
   • B. Cats is a bystander database.
   • C. The observer is connected to the database on which the query was executed.
   • D. The observer is currently running on o17.example com
   Reveal Answer

7. Question #7

   You must configure an Oracle Data Guard environment consisting of: 1. A primary database 2 Three Physical Standby Databases You must meet these requirements: ? A designated physical standby database should become the primary database automatically whenever the primary database falls ? The chosen protection mode should provide the highest level of protection possible without violating the other requirement Which redo transport mode and protection mode would you configure to meet these requirements?

   • A. SYNC NOAFFRIM and Maximum Protection
   • B. SYNC NOAFFIRM and Maximum Availability
   • C. ASYNC and Maximum Performance
   • D. SYNC AFFIRM and Maximum Availability
   Reveal Answer

8. Question #8

   You administer a Data Guard environment consisting of a primary and three physical standby databases. One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing. The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby. The physical standby database is the only standby that is a mandatory destination The broker configuration operates in MAXIMUM PERFORMANCE mode. Which ARCHIVELOG DELETION POLICY should be set. so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?

   • A. CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY
   • B. CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
   • C. CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
   • D. CONFIGURE ACHIVELOG DELETION POUCY TO SHIPPED TO STANDBY,
   Reveal Answer

9. Question #9

   Examine this list of possible steps: 1 Raise the compatibility level on both databases 2.Restart SQL Apply on the upgraded logical standby database 3 Start SQL Apply on the old primary database. 4. Perform a Switchover to the logical standby database 5. Upgrade the logical standby database. 6. Upgrade the old primary database. Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

   • A. 5,2.4,3,6,1
   • B. 1,5,2,4,6,3
   • C. 5,2,4,6,3,1
   • D. 4,6,5,2,3,1
   Reveal Answer

10. Question #10

    You need to ensure that the Data Guard configuration is in maximum availability mode. What must you do?

    • A. Set the standby database to maximum performance
    • B. Configure Data Guard broker
    • C. Use synchronous log shipping
    • D. Enable Fast Start Failover
    Reveal Answer