Oracle Database 19c: Data Guard Administration - 1z1-076 Exam Questions [2026]

QUESTION NO: 1
Which four factors can influence the rate of SQL apply on a logical standby database?

A. the number of full table scans performed by SQL apply B. the size of the shared pool C. the number of PREPAER processes D. the number of coordinator processes on the standby database instance E. the number of applier processes F. the size of the undo tablespace on the logical standby database

Correct Answer: A,C,D,E

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

QUESTION NO: 2
A customer asks you to propose the most appropriate solution for this set of requirements:
We need a disaster recovery solution that enables us to fail over from our production database with zero data loss.
We want to generate reports from the proposed standby database at the same time that it is used for data protection.
Developers may need to test occasionally on a copy of the live database Which TWO solutions would you recommend?

A. A physical standby database with real-time query enabled B. A physical standby database with real-time apply enabled C. A snapshot standby database with synchronous redo transport D. A logical standby database with real-time apply enabled E. A logical standby database with real-time query enabled

Correct Answer: A,E

QUESTION NO: 3
Which three statements are true about snapshot standby databases?

A. Tablespaces can be dropped. B. The switchover TO command allows a switchover operation to a snapshot standby database. C. Tables can be dropped. D. Tablespaces can be created. E. The FATLOVER TO command results in a transition of a snapshot standby database to the primary role. F. A logical standby database can be converted into a snapshot standby database.

Correct Answer: A,C,D

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

QUESTION NO: 4
Which three Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control?

A. You can monitor the redo apply rate on a logical standby database. B. You can set a critical threshold on the redo generation rate metric for a primary database. C. You can check if redo apply needs to be tuned. D. You can monitor the redo apply rate on a snapshot standby database. E. You can set a warning threshold on the redo generation rate metric for a physical standby database. F. You can check the potential data loss in the event of a disaster.

Correct Answer: A,B,F

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

QUESTION NO: 5
Which TWO statements are true regarding Data Guard Broker?

A. It automatically starts the DMON process for the database instances that are part of a Data Guard configuration. B. It can be used to create and manage standby databases. C. It can be used to perform failovers and switchovers. D. It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby. E. It can be used to monitor redo transport and log apply services.

Correct Answer: B,C

QUESTION NO: 6
Which three are true about using RMAN in a Data Guard environment?

A. 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. 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. Backups of data files taken on a physical standby are interchangeable with a primary. 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.

Correct Answer: B,C,D

QUESTION NO: 7
You are planning to perform block comparison using the dbms comp package:

Which TWO statements are true?

A. The databases should be at least mounted before block comparison. B. It requires that the DB_LOST_WKITE_protect initialization parameter be enabled. C. It can be used to detect lost writes and inconsistencies between the primary database and the cascaded standbys. D. You can monitor the progress of an ongoing block comparison operation by querying VS SES SION_LONGOPS. E. Logical standby databases can be the target database for the dbms_dbcomp.dbcomp procedure.

Correct Answer: A,D

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

QUESTION NO: 8
Which THREE statements are true about snapshot standby databases?

A. A snapshot standby database can have Real-Time apply enabled. B. A snapshot standby database may be opened read-write. C. FLASHBACK DATABASE is enabled automatically on a physical standby database as part of the conversion into a snapshot standby database, if not already enabled. D. A snapshot standby database may be opened read-only. E. FLASHBACK DATABASE is enabled automatically on a snapshot standby database after converting it from a physical standby database if not already enabled. F. FLASHBACK DATABASE must be manually enabled on a physical standby database before converting it into a snapshot standby database.

Correct Answer: B,C,E

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

QUESTION NO: 9
Which THREE statements are true about snapshot standby databases?

A. A snapshot standby database must be opened at least once in read-write mode before it can be converted into a physical standby database. B. A snapshot standby database can be the only standby database in a Maximum Protection Oracle Data Guard configuration. C. Snapshot standby databases may be used for rolling database upgrades. D. If datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database. E. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database.

Correct Answer: A,C,E