PracticeVideosBlogFlashcardsEspañol
All Practice Exams

100+ Free Oracle 1Z0-076 Practice Questions

Pass your Oracle Database 19c: Data Guard Administration exam on the first try — instant access, no signup required.

✓ No registration✓ No credit card✓ No hidden fees✓ Start practicing immediately
100+ Questions
100% Free

Loading practice questions...

Same family resources

Explore More Oracle Certifications

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Oracle SQL

Practice Questions1 blog

OCI AI Foundations

Practice Questions

OCI Architect

Practice Questions

OCI Foundations

Practice Questions

Oracle DBA

Practice Questions

OCI 2025 Data Science Professional (1Z0-1110-25)

Practice Questions

More From This Family

Videos and articles for deeper review.

ArticleOracle SQL 1Z0-071 Exam Guide 2026: Official Facts, Topic Traps, and Practice Plan12 min read
2026 Statistics

Key Facts: Oracle 1Z0-076 Exam

74 questions

Oracle 1Z0-076 contains 74 multiple-choice and multiple-select questions

Oracle - 1Z0-076 exam page

120 minutes

Time allowed to complete the 1Z0-076 exam

Oracle - 1Z0-076 exam page

61%

Passing score required for the 1Z0-076 exam

Oracle - 1Z0-076 exam page

3 modes

Data Guard protection modes: Maximum Performance, Availability and Protection

Oracle Data Guard Concepts and Administration 19c

Oracle Database 19c

Product version the 1Z0-076 exam is validated against

Oracle - 1Z0-076 exam page

Far Sync

Far Sync instances enable zero data loss protection over long distances

Oracle Data Guard Concepts and Administration 19c

DGMGRL

Data Guard Broker command-line manages configurations and fast-start failover

Oracle Data Guard Broker 19c

100

Free original practice questions available here

OpenExamPrep

Oracle Database 19c: Data Guard Administration (1Z0-076) is a proctored, professional-level exam with 74 multiple-choice and multiple-select questions, a 120-minute time limit and a 61% passing score, validated for Oracle Database 19c. It tests creating and managing physical and logical standby databases with SQL and RMAN, configuring redo transport and the Maximum Performance, Availability and Protection modes, and performing switchover and failover role transitions. It also covers the Data Guard Broker, fast-start failover with the observer, Far Sync instances, Active Data Guard real-time query and DML redirection, snapshot standbys, gap resolution and monitoring. Passing earns the Oracle Database 19c: Data Guard Administrator certification. This 100-question bank provides original practice modelled on those objectives.

Sample Oracle 1Z0-076 Practice Questions

Try these sample questions to test your Oracle 1Z0-076 exam readiness. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1What is the primary purpose of Oracle Data Guard?
A.To partition very large tables for query performance
B.To provide high availability, data protection and disaster recovery for Oracle databases
C.To compress redo so backups complete faster
D.To replicate data between Oracle and non-Oracle databases
Explanation: Oracle Data Guard maintains one or more synchronised standby databases from a production primary database, providing high availability, comprehensive data protection and disaster recovery. If the primary fails, a standby can take over the primary role.
2Which two types of standby database does Oracle Data Guard support?
A.Physical standby and logical standby
B.Hot standby and cold standby
C.Active standby and passive standby
D.Master standby and replica standby
Explanation: Data Guard supports physical standby databases, which use Redo Apply to maintain a block-for-block copy, and logical standby databases, which use SQL Apply to maintain a logically equivalent copy. Snapshot standbys are a variation created from a physical standby.
3How does a physical standby database stay synchronised with the primary?
A.By replaying SQL statements extracted from redo
B.By applying redo data block-for-block using Redo Apply (managed recovery)
C.By copying datafiles on a schedule
D.By using triggers to capture DML changes
Explanation: A physical standby uses Redo Apply, which is media recovery applied continuously. It applies the same redo received from the primary so the standby is an exact, block-for-block physical copy of the primary database.
4Which apply technology does a logical standby database use?
A.Redo Apply
B.SQL Apply
C.Block Change Apply
D.Snapshot Apply
Explanation: A logical standby uses SQL Apply. The LogMiner-based mechanism transforms received redo into SQL statements and executes them on the standby, so the standby is logically (not physically) identical and can be open read-write for tables that are not being maintained.
5A snapshot standby database is best described as:
A.A physical standby permanently open read-write
B.A physical standby converted to be open read-write that discards local changes when converted back
C.A logical standby used only for reporting
D.A standby that stores only block change tracking data
Explanation: A snapshot standby is created by converting a physical standby. It is fully updatable and open read-write, useful for testing. When converted back to a physical standby, all local changes are discarded using Flashback Database and the accumulated primary redo is applied.
6Which background process on the primary database is primarily responsible for transmitting redo to a standby?
A.The Log Writer (LGWR) only
B.The Network Server (NSSn/NSAn) and archiver processes acting as redo transport services
C.The Database Writer (DBWn)
D.The Checkpoint process (CKPT)
Explanation: Redo transport services use network server processes (NSSn for SYNC, NSAn for ASYNC) and archiver (ARCn) processes to ship redo from the primary to standby destinations. LGWR writes redo locally but the transport is handled by these transport processes.
7On a physical standby, which process receives redo from the primary and writes it to standby redo logs?
A.The Remote File Server process (RFS)
B.The Log Writer (LGWR)
C.The Job Queue process (Jnnn)
D.The System Monitor (SMON)
Explanation: The Remote File Server (RFS) process on the standby receives redo transmitted by the primary's transport processes and writes it to standby redo logs (or archived redo logs). The apply processes then apply that redo.
8What is the recommended way to create standby redo logs on a standby database?
A.Create one more standby redo log group than the number of online redo log groups on the primary, all sized at least as large as the largest online redo log
B.Create exactly one standby redo log group regardless of primary configuration
C.Create fewer groups than the primary so apply is faster
D.Standby redo logs are created automatically and should never be added manually
Explanation: Oracle recommends configuring standby redo logs that are the same size as (or larger than) the largest online redo log and creating at least one more group per thread than the number of online redo log groups on the primary. This avoids a transport process having to wait for a log to be archived.
9Which RMAN command is commonly used to create a physical standby database directly from the running primary over the network?
A.DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE
B.RESTORE STANDBY FROM PRIMARY
C.CREATE STANDBY DATABASE
D.RECOVER STANDBY USING BACKUP
Explanation: RMAN's DUPLICATE TARGET DATABASE FOR STANDBY FROM ACTIVE DATABASE creates a physical standby by copying the live primary over the network, without needing a pre-existing backup. It restores datafiles and creates the standby control file in one operation.
10Which initialization parameter specifies a unique name for each database in a Data Guard configuration so they can be distinguished even after a role transition?
A.DB_NAME
B.DB_UNIQUE_NAME
C.INSTANCE_NAME
D.SERVICE_NAMES
Explanation: DB_UNIQUE_NAME gives each member of a Data Guard configuration a distinct identity while DB_NAME stays the same across primary and standbys. Redo transport destinations and the broker reference databases by their DB_UNIQUE_NAME.

About the Oracle 1Z0-076 Exam

Oracle Database 19c: Data Guard Administration (1Z0-076) is a professional-level certification exam for database administrators responsible for high availability and disaster recovery using Oracle Data Guard. It validates the ability to create and manage physical and logical standby databases with SQL and RMAN, configure redo transport and the three protection modes, manage Oracle Net Services, perform switchover and failover role transitions, and use the Data Guard Broker including fast-start failover. The exam also covers Active Data Guard real-time query and DML redirection, Far Sync instances, snapshot standbys, gap resolution, monitoring and tuning, and rolling upgrades. Passing the exam earns the Oracle Database 19c: Data Guard Administrator certification.

Assessment

74 multiple-choice and multiple-select questions covering Data Guard architecture, physical and logical standby databases, redo transport, protection modes, role transitions, the Data Guard Broker, fast-start failover and Active Data Guard.

Time Limit

120 minutes.

Passing Score

61%.

Exam Fee

Typically US$245; pricing varies by country and is subject to change. Confirm the current fee when registering through Oracle and Pearson VUE. (Oracle (delivered through Pearson VUE))

Oracle 1Z0-076 Exam Content Outline

30%

Data Guard architecture and standby databases

Data Guard components and benefits, physical standby creation using SQL and RMAN DUPLICATE, logical standby creation and SQL Apply, snapshot standbys, Redo Apply, Oracle Net Services configuration and the broker-independent SQL interface.

20%

Redo transport and protection modes

Synchronous (SYNC AFFIRM) and asynchronous (ASYNC) redo transport, the Maximum Performance, Maximum Availability and Maximum Protection modes, Far Sync instances for zero data loss over distance, real-time apply, and detecting and resolving archive log gaps.

30%

Role transitions and the Data Guard Broker

Switchover and failover including complete and immediate failover, Flashback Database to reinstate a failed primary, Data Guard Broker configuration with DGMGRL, fast-start failover, the observer process and FastStartFailoverThreshold.

20%

Active Data Guard, monitoring and patching

Active Data Guard real-time query, DML redirection from a read-only standby, Data Guard monitoring with views such as V$DATAGUARD_STATS and the broker, performance tuning, and Data Guard standby-first patching and rolling upgrades.

How to Pass the Oracle 1Z0-076 Exam

What You Need to Know

  • Passing score: 61%.
  • Assessment: 74 multiple-choice and multiple-select questions covering Data Guard architecture, physical and logical standby databases, redo transport, protection modes, role transitions, the Data Guard Broker, fast-start failover and Active Data Guard.
  • Time limit: 120 minutes.
  • Exam fee: Typically US$245; pricing varies by country and is subject to change. Confirm the current fee when registering through Oracle and Pearson VUE.

Keys to Passing

  • Complete 500+ practice questions
  • Score 80%+ consistently before scheduling
  • Focus on highest-weighted sections
  • Use our AI tutor for tough concepts

Oracle 1Z0-076 Study Tips from Top Performers

1Build a two-node Data Guard lab with Oracle Database 19c and practise creating a physical standby using RMAN DUPLICATE FROM ACTIVE DATABASE; most exam scenarios assume you have done this hands-on.
2Memorise the three protection modes and their exact redo transport attributes: Maximum Performance uses ASYNC, Maximum Availability and Maximum Protection use SYNC AFFIRM, and only Maximum Protection will stall the primary to guarantee zero data loss.
3Practise both switchover and failover in DGMGRL, and rehearse reinstating a failed primary with Flashback Database after a failover; the exam tests the order of these steps.
4Understand fast-start failover thoroughly: the observer, FastStartFailoverThreshold, the FS_FAILOVER_OBSERVER_PRESENT and FS_FAILOVER_STATUS columns, and which conditions trigger an automatic failover.
5Know the difference between a physical standby (Redo Apply, block-for-block), a logical standby (SQL Apply, can be open read-write for other schemas) and a snapshot standby (open read-write, discards changes on convert back).
6Review Active Data Guard features for 19c, especially real-time query and DML redirection, and how Far Sync provides zero data loss protection over long distances without applying redo.

Frequently Asked Questions

How many questions are on the Oracle 1Z0-076 exam and how long is it?

The 1Z0-076 exam has 74 questions and a time limit of 120 minutes. The questions are multiple choice and multiple select, delivered through a proctored Pearson VUE session.

What passing score do I need for 1Z0-076?

The passing score is 61%. The exam is validated for Oracle Database 19c, so all questions assume the 19c feature set and command syntax.

What certification do I earn by passing 1Z0-076?

Passing 1Z0-076 earns the Oracle Database 19c: Data Guard Administrator certification, which recognises skills in high availability and disaster recovery using Oracle Data Guard.

What are the three Data Guard protection modes?

Maximum Performance is the default and uses asynchronous redo transport. Maximum Availability uses synchronous transport but never stalls the primary indefinitely. Maximum Protection guarantees zero data loss and will stall or shut down the primary if no synchronous standby can confirm redo.

Do I need hands-on experience to pass 1Z0-076?

Yes. The exam tests practical configuration of physical and logical standbys, redo transport, the Data Guard Broker and fast-start failover, so hands-on lab practice with Oracle Database 19c is strongly recommended.

Are these official Oracle exam questions?

No. These are original OpenExamPrep practice questions modelled on the 1Z0-076 objectives. Oracle provides the official exam through Pearson VUE and publishes the documentation separately.