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: Mar 11, 2026

Add To Cart

Question 1

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 2

What is the purpose of the SKIP clause in a logical standby database configuration?

A : To skip applying specific SQL statements to the standby database

B : To skip applying specific redo logs to the standby database

C : To skip applying specific network configurations to the standby database

D : To skip applying specific supplemental logging settings to the standby database

Answer: A

Question 3

Which of the following can be configured to enable transparent failover in a Data Guard environment?

A : Oracle Clusterware

B : Data Guard Broker

C : Oracle Net Services

D : Fast Application Notification (FAN)

Answer: D

Question 4

Which of the following options provides automatic data repair in a read-only standby database?

A : LogMiner

B : Real Application Testing

C : Data Guard Broker

D : Flashback Database

Answer: D

Question 5

What is a failover in Oracle Data Guard?

A : A process of switching the roles of the Primary and Secondary databases

B : A process of automatically promoting the Secondary database as the new Primary in case of a failure

C : A process of synchronizing data between databases in real-time

D : A process of copying data from the Primary database to the Secondary database

Answer: B

Page: 1 / 110

Total 546 Questions | Updated On: Mar 11, 2026

Add To Cart