1. Home
  2. Oracle
  3. 1Z0-066

Oracle 1Z0-066 Online Practice Questions and Exam Preparation

1Z0-066 Exam Details

  • Exam Code
    :1Z0-066
  • Exam Name
    :Oracle Database 12c: Data Guard Administrator
  • Certification
    :Oracle Certifications
  • Vendor
    :Oracle
  • Total Questions
    :204 Q&As
  • Last Updated
    :May 25, 2026

Oracle 1Z0-066 Online Questions & Answers

  • Question 111:

    Examine the Data Guard configuration:

    Which three will be true after a switchover to Sheep?

    A. Cats will be an enabled logical standby database
    B. Cats will be a disabled logical standby database.
    C. Dogs will be a logical standby database.
    D. Dogs will be a physical standby database
    E. Sheep will be the primary database.

  • Question 112:

    A query on the view DBA_LOGSTBY_UNSUPPORTED on your primary database returns no rows

    As a result of this, you decide that an upgrade may use logical standby databases.

    Which two are true about upgrading Data Guard environments consisting of one logical standby database running on a separate host from the primary?

    A. The upgrade always requires downtown until the upgrade of the logical standby is completed
    B. Using manual upgrade, catctl.pl can be executed in some cases on the primary and standby database simultaneously.
    C. The upgrade always required downtime until the upgrade of the primary is completed
    D. Using manual upgrade, catupgr.sql needs to run on the primary database only.
    E. SQL Apply on the local standby database must be stopped while the primary database is upgraded.
    F. Fast-Start Failover can be used to protect the primary database during the upgrade.

  • Question 113:

    Which two are true about the creation of a Data Guard Broker configuration?

    A. in a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file.
    B. A primary database profile may be added to the configuration prior to creating the primary database.
    C. A standby database profile may be added to the configuration prior to creating that standby database.
    D. A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created.
    E. A newly created broker configuration is in the disabled state

  • Question 114:

    You must use a physical standby database file to recover a data file on a primary database in a Data Guard environment.

    Which three of these steps must be performed on the primary database after the file has been backed up using RMAN on the physical standby database?

    A. Connect to the primary database as the AUXILIARY.
    B. Catalog the data file copy for RMAN to use on the primary database for restore.
    C. Back up the data file as copy on the standby host to a location on the standby host.
    D. Switch to the data file copy using the RMAN SWITCH command.
    E. Back up the data file as copy on the standby host to a location on the primary host
    F. Connect to the primary database as the TARGET.

  • Question 115:

    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
    E. ASYNC and Maximum Performance

  • Question 116:

    Examine the Data Guard configuration:

    DGMGRL> show configuration;

    Configuration ?Animals

    Protection Mode: MaxAvailability

    Databases:

    dogs - Primary database cats - Physical standby database sheep - Logical standby database

    Fast-Start Failover: DISABLED Configuration Status: ORA-01034: ORACLE not available

    ORA-16625: cannot reach database "dogs"

    DGM-17017: unable to determine configuration status

    Which three will be true after a successful failover to Sheep? (Choose three.)

    A. Cats will be in the disabled state and must be manually reinstated.
    B. Cats will be in the disabled state and must be manually re-created.
    C. Dogs will be in the disabled state and must be manually re-created.
    D. Dogs will be in the disabled state and must be manually reinstated.
    E. The configuration will be in Maximum Performance mode.
    F. The configuration will be in Maximum Availability mode.

  • Question 117:

    Attempting to start the observer raises an error:

    DGMGRL> start observer:

    DGM-16954: Unable to open and lock the Observer configuration file Failed.

    Identify two possible reasons for this error

    A. Fast-Start Failover is not yet enabled for this Data Guard configuration
    B. The observer configuration file is marked read-only.
    C. There is already an observer running for this Data Guard configuration.
    D. There is another observer running for a Data Guard configuration which uses the same observer configuration file
    E. The broker configuration has not yet been created.

  • Question 118:

    Which two Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

    A. monitoring the redo apply rate on a physical standby
    B. monitoring the redo apply rate on a logical standby
    C. monitoring the undo generation rate on a logical standby
    D. monitoring the redo apply rate on a snapshot standby
    E. monitoring the transport lag
    F. monitoring the undo generation rate on the primary

  • Question 119:

    Which three are always benefits of using a logical standby database?

    A. it can be used for database rolling release upgrades
    B. it can be used to replicate a single pluggable database (PDB) in a multitenant container database.
    C. It can be used as an updatable database for Real Application testing and then converted back to a standby database without affecting the updates.
    D. It can be used for reporting workloads requiring additional indexes or materialized views or both.
    E. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database.
    F. it can be used for testing patches without affecting the primary database.

  • Question 120:

    Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?

    A. Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter.
    B. Put the primary database into archivelog mode
    C. Startup nomount the standby database instance.
    D. Configure Oracle Net connectivity on the primary host to the standby database instance.
    E. Establish user equivalence for the database software owner between the primary host and standby host.

Related Exams:

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-066 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.