Oracle Database 19c 1z1-076

The Oracle Database 19c: Data Guard Administration exam has a reputation for breadth, and many candidates underestimate how much ground it covers. Getcertkey closes those gaps with 111 practice questions that reflect the style and difficulty you can expect in 2026.

Oracle 1z1-076 Exam Overview:

Certification Vendor:	Oracle
Exam Name:	Oracle Database 19c: Data Guard Administration
Exam Number:	1Z0-076
Exam Price:	$245 USD
Certificate Validity Period:	3 years
Available Languages:	English
Exam Format:	Multiple Select, Multiple Choice
Real Exam Qty:	74 - 80
Related Certifications:	Oracle Database 12c Administrator Certified Professional Oracle Database 11g Administrator Certified Professional Oracle Certified Expert, Oracle Database 12c: Data Guard Administrator Oracle Database Administration 2019 Certified Professional
Exam Duration:	120 minutes
Passing Score:	60%
Recommended Training:	Oracle Database 19c: Data Guard Administration Training
Exam Registration:	Oracle University Registration
Sample Questions:
Exam Way:	Online proctored or Onsite at authorized test centers
Pre Condition:	Must hold one of: Oracle Database Administration 2019 Certified Professional, Oracle Database 12c Administrator Certified Professional, Oracle Certified Expert 12c Data Guard Administrator, or Oracle Database 11g Administrator Certified Professional
Official Syllabus URL:	https://education.oracle.com/oracle-database-19c-data-guard-administration/pexam_1Z0-076

Oracle 1z1-076 Exam Syllabus Topics:

1z1-076 Exam FAQs for 2026 Candidates

Which certification does the 1z1-076 exam lead to?

The 1z1-076 exam is the official Oracle exam behind the Oracle Certified Professional, Oracle Database 19c: Data Guard Administrator certification, validating the skills measured by the Oracle Database 19c: Data Guard Administration credential. It sits at the Professional level of the Oracle certification program. It also connects to Oracle Database Administration 2019 Certified Professional, Oracle Database 12c Administrator Certified Professional, Oracle Certified Expert, Oracle Database 12c: Data Guard Administrator, Oracle Database 11g Administrator Certified Professional, so the knowledge you build here carries over to those tracks as well.

How many questions are on the 1z1-076 exam, and how much time do I get?

The 1z1-076 exam contains 74 - 80 questions to be completed within 120 minutes. Before exam day, divide the available time by the question count to work out a comfortable per-question pace, and mark any item that eats into it so you can return later instead of getting stuck. Timed sessions in the Getcertkey test engines make that pacing automatic — run at least two full-length mock exams under the clock so time pressure never becomes the reason you drop points.

What score do I need to pass the 1z1-076 exam, and what does it cost?

The passing score for the 1z1-076 exam is 60%, and the official registration fee is $245 USD. Retakes are not discounted — every new attempt means paying the full fee again — so it pays to measure yourself before you book. Work through the 111 practice questions on Getcertkey, sit a timed practice test, and schedule your exam only when your scores are consistently comfortable. That simple habit is the cheapest exam strategy there is.

Are there any prerequisites for the 1z1-076 exam?

Must hold one of: Oracle Database Administration 2019 Certified Professional, Oracle Database 12c Administrator Certified Professional, Oracle Certified Expert 12c Data Guard Administrator, or Oracle Database 11g Administrator Certified Professional Requirements can change when Oracle revises its certification program, so confirm the current eligibility rules on the official exam page before you register.

How do I register for the 1z1-076 exam?

You can book the Oracle Database 19c: Data Guard Administration exam through the official registration channels below:

• Oracle University Registration

As for delivery, the exam is offered in the following format: Online proctored or Onsite at authorized test centers. Choose the option that suits you best when you book your seat.

What official training is recommended for the 1z1-076 exam?

Oracle recommends the following training resources for the Oracle Database 19c: Data Guard Administration exam:

• Oracle Database 19c: Data Guard Administration Training

Official courses build the foundation; the 111 practice questions from Getcertkey then show you how that knowledge is examined, so the two work best together.

Can I try the 1z1-076 practice questions before I buy?

Yes. Getcertkey provides a free 1z1-076 PDF demo so you can review the question style and answer quality before purchasing. Every purchase also includes 365 days of free updates — if Oracle revises the exam during that period, the updated material reaches you at no cost. Once the free-update year ends, you can extend your update service at a 50% discount.

What if I fail the 1z1-076 exam, and how is my order delivered?

Every Oracle Database 19c: Data Guard Administration purchase on Getcertkey is covered by a 100% money-back guarantee with clear conditions: if you take the corresponding exam within 60 days of your purchase and do not pass, you can claim a full refund by submitting a scanned copy of your exam enrollment slip and your official score report as a PDF within two days of the exam date; claims are processed within seven days of submission. The guarantee does not apply to exams taken within three days of purchase, to material that was downloaded but never used in an exam attempt, or to free products and expired orders, and the candidate name must match the payer name. If you would rather not take a refund, you can instead exchange your purchase for two free exam preparation products of equal value and keep the update service on your original product.

Delivery is instant: your download is sent to your email within one minute of payment, with no limit on how many computers you may install the material on. If nothing arrives within two hours, check your spam folder and contact customer service for help.

What topics are covered in the 1z1-076 exam?

The Oracle Database 19c: Data Guard Administration exam blueprint is organized into 4 domains. The first three are:

• Data Protection and Performance — 20% of the exam
• Data Guard Architecture and Configuration — 30% of the exam
• Role Transitions and Switchover/Failover — 25% of the exam

For the complete domain-by-domain breakdown, scroll up to the full exam topics outline above and use it to plan how you distribute your study time.

Oracle Database 19c: Data Guard Administration Sample Questions:

Question #1
Which three types of backups offload ........ with the primary database in a data Guard

A. Archive logs
B. Control files
C. Broker configuration files
D. Password files
E. Data files
F. Online logs

Question #2
Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration - Animals
Protection Mode: MaxAvailability
Databases:
dogs - Primary database
cats - Snapshot standby database
sheep - Snapshot 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
ou wish to perform a failover to sheep. Which command, or sequence of commands, should you issue to the broker before executing failover to sheep; using the broker?

A. DGMGRL> convert database sheep to physical standby;
B. None, because you can directly failover to a Snapshot Standby Database.
C. DGMGRL> convert database cats to physical standby;
D. DGMGRL> convert database sheep to physical standby;
DGMGRL> edit configuration set protection mode as maxperformance;
DGMGRL> convert database sheep to physical standby;
E. DGMGRL> convert database cats to physical standby;

Question #3
You created the PRODSBY1 physical standby database for the PROD primary database using gql and RMAN. You are planning to create a Data Guard Broker configuration. You execute the command:

Which three statements are true regarding the execution of the command?

A. The command will execute successfully only if the DG_BROKER_START initialization parameter is set to TRUE for the PROD database instance.
B. The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBYl database instances are defined on the primary host.
C. The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.
D. The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.
E. The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START is TRUE for PRODSBYl.
F. The PRODSBYI standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBYl database instance is defined on the primary host.

Question #4
Which two are true about database roles in an Oracle Data Guard configuration?

A. A Logical Standby Database can cascade redo to a terminal destination.
B. A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.
C. A Logical Standby Database can be converted to a Snapshot Standby Database.
D. A Snapshot Standby Database can be a fast-start failover target.
E. A Physical Standby Database can be converted into a Logical Standby Database.

Question #5
Your Data Guard environment has one physical standby database using Real-Time Query. Two sequences have been created by these SQL statements:

Neither sequence has been used since being created.
Session 1 connects to the primary database instance and issues these two SQL statements:
SELECT a.nextval FROM DUAL; SELECT b.nextval FROM DUAL;
Then session 2 connects to the physical standby database instance and issues the same SQL statements. Which output will be seen for session 2?
Then session 2 connects to the physical standby database instance and issues the same SQL statements. Which output will be seen for session 2?
A)

B)

C)

A. Option C
B. Option B
C. Option A
D. Option D

Solutions: