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: Oct 26, 2026

Add To Cart

Question 1

Which THREE are among the various tasks performed by the Data Guard Monitor (DMON) process?

A : performing role transitions when switchover requests are made

B : maintaining information about all members of the broker configuration in binary configuration files.

C : activating role-based services appropriately in the various database instances of the configuration, based on the database role

D : communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required

E : communicating with dkon processes in other database instances that are part of the broker configuration

Answer: A,B,C

Question 2

What is the purpose of the SKIP_UNUSABLE_INDEXES initialization parameter in a Logical Standby Database?

A : It allows the primary database to ignore any unusable indexes on the standby database.

B : It skips the application of unusable indexes during SQL apply on the standby database.

C : It allows creation of unusable indexes on the standby database.

D : It skips the creation of unusable indexes on the primary database.

Answer: B

Question 3

Your Data Guard configuration consists of these components and settings: 1. A primary database 2. A remote physical standby database 3. Real-time query is enabled 4. Redo transport mode is synchronous 5. Protection mode is maximum availability 6. The Data Guard broker is used You notice that the standby destination fails to acknowledge reception of redo within net_timeout period of time. Which is true in this scenario?

A : Real-time query will be disabled on the physical standby.

B : The protection mode will automatically change to Maximum Performance.

C : Synchronous redo transport mode connections to the standby database are terminated.

D : The physical standby database instance is shut down by the Data Guard broker.

Answer: C

Question 4

What happens to a DDL statement executed on the primary database in a logical standby database?

A : It generates an error on the logical standby database.

B : It is ignored on the logical standby database.

C : It waits for manual confirmation on the logical standby database.

D : It is executed and applied immediately on the logical standby database.

Answer: B

Question 5

How can you verify if the physical standby database is in sync with the primary database?

A : By running the VALIDATE DATABASE command in RMAN on the primary database.

B : By checking the error logs on the standby database.

C : By checking the alert log on the primary database.

D : By comparing the SCN values on the primary and standby databases.

Answer: D

Page: 1 / 110

Total 546 Questions | Updated On: Oct 26, 2026

Add To Cart