Free Oracle 1z1-076 Practice Test & Real Exam Questions

Exam Code/Number: 1z1-076
Exam Name/Title: Oracle Database 19c: Data Guard Administration
Certification Provider: Oracle
Corresponding Certification: Oracle Database 19c

Exam Questions: 111
Updated On: Jul 06, 2026

Question #1

Which THREE statements are true about snapshot standby databases?

A. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

B. A snapshot standby database must be opened at least once in read-write mode before it can be converted into a physical standby database.

C. If datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database.

D. Snapshot standby databases may be used for rolling database upgrades.

E. A snapshot standby database can be the only standby database in a Maximum Protection Oracle Data Guard configuration.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #2

Which three are true about using RMAN in a Data Guard environment?

A. Backups of data files taken on a physical standby are interchangeable with a primary.

B. Backups of control files taken on a physical standby are not interchangeable with a primary.

C. Backups of archived redo logs taken on a physical standby are interchangeable with a primary.

D. A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups.

E. A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.

Discussion 0

Correct Answer: A,B,C Vote an answer

Question #3

Which three are prerequisites for enabling Fast-Start Failover?

A. Flashback Database must be enabled only on the Fast-Start Failover target standby database.

B. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database.

C. The maximum protection mode can be used, but with two or more standby databases.

D. The configuration must be operating in either Maximum Performance or Maximum Protection mode.

E. The Data Guard environment must be managed by the Data Guard Broker.

F. You can specify only one standby database as the fast-start failover target.

Discussion 0

Correct Answer: B,E,F Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #4

Which feature is available when monitoring a Data Guard configuration using Enterprise Manager Cloud Control, but is not available using DGMGRL or by using SQL?

A. Automatic creation of standby redo logs

B. Creating a broker configuration before creating the databases

C. Analyzing the dmon process trace file

D. Performing a verify operation

E. Viewing a logical standby database apply lag

Discussion 0

Correct Answer: E Vote an answer

Question #5

Examine the following parameter settings of the physical standby database:
* STANDBY_FILE_MANAGEMENT=AUTO
* ENABLED_PDBS_ON_STANDBY=<null>
During which TWO tasks are files automatically created in the physical standby database after structure changes on the primary database?

A. Adding or dropping a redo file group

B. Renaming a data file in the primary database

C. Adding a data file or creating a tablespace

D. Performing transportable tablespaces

E. Creating a PDB from the existing PDB within the same CDB

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #6

Which TWO statements correctly describe the behavior of Automatic Block Media Recovery in a Data Guard environment, for a corrupt block in the example tablespace encountered by a session logged in as the SH user?

A. A corrupt block on the primary database is automatically recovered, using a block from a flashback log from a standby database with Real-Time Query enabled.

B. A corrupt block on the primary database is automatically recovered, using a block from a flashback log from the primary database.

C. A corrupt block on the primary database can be automatically recovered, using a block from a standby database with Real-Time Query enabled.

D. A corrupt block on a standby database with Real-Time Query enabled, is automatically recovered, using flashback logs from the standby database.

E. A corrupt block on a standby database with Real-Time Query enabled, can be automatically recovered, using a block from the primary database.

Discussion 0

Correct Answer: B,C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #7

Which three are prerequisites for using Data Guard Broker?

A. The broker configuration files for a RAC database must reside in shared storage accessible by all the RAC database instances.

B. The primary and standby databases must run the same version of the Oracle Database server.

C. If any database in the configuration is a RAC database, then the broker configuration files must reside in shared storage accessible by all database instances for all databases in the broker configuration.

D. Network connectivity to the primary database instance must be defined on the servers hosting the standby database instances.

E. A statically defined listener end-point must be registered with the local listener on the servers hosting the standby database instances.

F. DG_BROKEB_START must be set to TRUE for a database instance before adding the database to the broker configuration.

Discussion 0

Correct Answer: B,C,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #8

Which three are true about using RMAN in a Data Guard environment?

A. Backups of data files taken on a physical standby are interchangeable with a primary.

B. Backups of control files taken on a physical standby are not interchangeable with a primary.

C. Backups of archived redo logs taken on a physical standby are interchangeable with a primary.

D. A recovery catalog is required when RMAN is used to take backups from a physical standby database if you plan to recover the primary using those backups.

E. A recovery catalog is required when RMAN is used to take backups from a logical standby database in a Data Guard configuration if you plan to recover the primary using those backups.

Discussion 0

Correct Answer: A,B,C Vote an answer

Question #9

Examine this query and its output:

Which two statements are true?

A. The master observer is connected to the database on which the query was executed.

B. Cats is a bystander database.

C. The master observer is currently running on ol7.example.com.

D. The master observer is not running, but should run on ol7.example.com.

E. The master observer is not connected to the database on which the query was executed.

Discussion 0

Correct Answer: B,E Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Download Free Oracle 1z1-076 Demo

Simply submit your e-mail address below to get started with our free demo of your Oracle 1z1-076 exam.