1Z0-076: Oracle Database 19c: Data Guard Administration

By Oracle · Browse Mode
About the Exam

Oracle lists this exam as covering Oracle Data Guard concepts, configuration, management, optimization, and monitoring, with emphasis on data protection, high availability, and disaster recovery. It is aimed at experienced database administrators; Oracle says ideal candidates typically have 4 to 5 years of database administration experience and 2 to 3 years of Data Guard experience. Passing the exam is one requirement for the Oracle Certified Professional, Oracle Database 19c: Data Guard Administrator certification.

Exam Topics

  • Oracle Data Guard Overview20%
  • Creating a Physical Standby Database16%
  • Managing the Redo Transport Services12%
  • Managing Log Apply Services12%
  • Configuring and Managing Oracle Data Guard Broker14%
  • Performing Role Transitions14%
  • Monitoring a Data Guard Configuration12%

How to Use This Practice Exam

  1. Browse — Read each question, select your answer, and reveal the explanation.
  2. Exam Mode — Simulate real exam conditions with a timed session and score report.
  3. Learn Mode — Spaced repetition schedules questions you struggle with for long-term retention.

Download the Full Exam PDF

Get every question and answer in a clean, printable PDF built for offline study. Purchase once, keep permanent access, and re-download the latest version anytime.

Get PDF
Learn More

Last updated December 3, 2025 at 2:54 PM

Topic filter
Question status
Question sort
Questions per page

QuestionQ1

VerifiedPerforming Role Transitions

Examine the following command, which is run on a physical standby database to convert it to a logical standby database:

SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;

Which two statements are true about executing this command?

Choose two
Explanation

ALTER DATABASE RECOVER TO LOGICAL STANDBY continues applying redo on the physical standby until the required LogMiner dictionary is located, which is performed by managed recovery. Without the KEEP IDENTITY clause, the conversion also changes the database DBID. SQL Apply is started separately after conversion; supplemental logging and Flashback are not automatically enabled by this statement.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ2

VerifiedConfiguring and Managing Oracle Data Guard Broker

Which three conditions are required before using Data Guard Broker?

Choose three
Explanation

Data Guard Broker requires the primary and standby databases to run the same Oracle Database version. DG_BROKER_START must be set to TRUE before a database participates in the broker configuration. For an Oracle RAC database, the DG_BROKER_CONFIG_FILEn parameters must reference the same shared broker configuration files for every instance of that RAC database; this requirement does not apply to non-RAC databases elsewhere in the configuration.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ3

VerifiedMonitoring a Data Guard Configuration

Which TWO statements are correct about block media recovery in a Data Guard environment?

Choose two
Explanation

Automatic Block Media Recovery in a Data Guard configuration lets the primary database automatically retrieve an uncorrupted copy of a data block from a physical standby database that is open in real-time query (Active Data Guard) mode, transparently repairing the corruption without manual RMAN intervention. Enabling this automatic repair additionally depends on setting the DB_LOST_WRITE_PROTECT initialization parameter to TYPICAL on both the primary and standby databases, which activates the redo-based block validation needed to detect and safely correct corrupt or lost-write blocks; FULL is not the documented setting required to enable this feature.

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ4

VerifiedOracle Data Guard Overview

You need to propose an Oracle Data Giard configuration for a database that supports an OLTP workload and meets these permanent requirements:

  1. Data loss is not allowed.
  2. Read-only applications must not connect to the primary database instance.

Additionally, the following requirements exist, with only one ever performed at a time:

  1. It must be possible to apply and test designated patches with minimal downtime.
  2. An upgrade to a new database release must be performed with the least possible downtime.
  3. New application software releases must be tested against an exact, up-to-date replica of the production database.

You propose a primary database with one physical database configured in Maximum Protection mode.

Which requirements are met?

Explanation

Maximum Protection guarantees no data loss when the primary fails, and a physical standby can be opened for read-only access to offload queries from the primary. With only that single physical standby, the configuration cannot preserve Maximum Protection while using the standby as a snapshot or transient logical standby for general patch testing, rolling release upgrades, or writable application-release testing. A snapshot standby also cannot be the only standby in a Maximum Protection configuration.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!

QuestionQ5

VerifiedOracle Data Guard Overview

Which three statements are accurate about snapshot standby databases?

Choose three
Explanation

A snapshot standby database is opened read-write and is fully updatable, permitting operations such as dropping tables and creating tablespaces. It can be the target of a manual FAILOVER TO operation; the broker converts it to a physical standby, applies accumulated redo, and transitions it to the primary role. A switchover to a snapshot standby is not allowed, and a dropped tablespace’s data file cannot be restored by Flashback Database.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!
Know a question that should be here? Contribute to this exam
Back home