Free Oracle 1Z0-076 Exam Questions

Become Oracle Certified with updated 1Z0-076 exam questions and correct answers

Page: 1 / 110

Total 546 Questions | Updated On: May 11, 2026

Add To Cart

Question 1

Which TWO statements are true for Data Guard environments with multi-tenant databases?

A : A multi-tenant standby database can have fewer pluggable databases than the primary container database.

B : Different pluggable databases within a logical standby database may have different guard statuses.

C : The Data Guard broker automatically opens all pluggable databases of a primary database after a role change operation.

D : The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation.

E : The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database.

Answer: A,B

Question 2

What is the primary purpose of Oracle Data Guard Fast-Start Failover?

A : To optimize query performance on the Primary database.

B : To provide a scalable and highly available network infrastructure for Data Guard.

C : To automate the backup and recovery process for Data Guard databases.

D : To reduce downtime by automatically detecting failures and triggering failover.

Answer: D

Question 3

Which initialization parameter needs to be set to enable a snapshot standby database?

A : ENABLE_SNAPSHOT_STANDBY

B : ENABLE_DGMGRL_SNAPSHOT

C : DB_RECOVERY_FILE_DEST

D : STANDBY_ARCHIVE_DEST

Answer: A

Question 4

What are the two types of standby databases in Oracle Data Guard?

A : Online and offline.

B : Primary and secondary.

C : Physical and logical.

D : Active and passive.

Answer: C

Question 5

What is the main advantage of using a snapshot standby database over a physical standby database?

A : Improved performance for reporting and queries

B : Reduced disk space requirements

C : Ability to apply redo logs to update the standby database

D : Faster failover and switchover capabilities

Answer: A

Page: 1 / 110

Total 546 Questions | Updated On: May 11, 2026

Add To Cart