Oracle 1Z0-066 Exam Questions & Answers

Which three statements are true about standby redo logs in a Data Guard configuration with no Oracle Streams or Goldengate configured?

A. They are required on a logical standby for real-time apply

B. They are required only for synchronous redo transport.

C. Only standby databases can write redo to them.

D. It is recommended to have them on the primary database.

E. They are required on a physical standby for real-time apply.

F. The LGWR process writes to them on a standby database.

You are required to change the Data Guard Configuration protection mode from MAXPERFORMANCE to MAXAVAJLABILITY using Enterprise Manager Cloud Control

Which two are true about this change?

A. If the primary database cannot write its redo to at least one synchronized standby database, then the protection level remains unchanged.

B. The primary database instance will remain up and running, if it cannot write redo to at least one synchronized standby database.

C. Transactions will not commit until all redo data needed to recover those transactions are written to the online redo log, and to the standby redo log on at least one synchronizes standby database.

D. Fast start failover can be enabled when making the chance.

E. Real time apply will be automatically turned on.

You have a Data Guard broker configuration consisting of:

1.

A primary database

2.

One local physical standby database

3.

One far sync instance

4.

A remote physical standby database

The broker configuration was created with the DGMGRL utility after creating all the databases and the far sync instance with command-line tools.

What is the correct way to add this configuration to Enterprise Manager Cloud Control assuming all the nodes have been discovered already as Enterprise Manager targets?

A. Use the DGMGRL utility to register the configuration with the Enterprise manager Cloud Control agent on the primary database node. This will enable the discovery of all the other databases in the configuration as targets which will be ready to be monitored.

B. Discover the primary database as a target in Enterprise Cloud Control. Then discover the existing Data Guard Broker configuration for the primary and all the other databases in the configuration will be discovered as targets and be ready to be monitored.

C. Discover either of the physical standby databases as a target by refreshing the node on which they run, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.

D. Discover the primary as a target by refreshing the node on which it runs, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.

E. Delete the Data Guard Broker configuration using DGMGRL and then re-create it using Enterprise Manager Cloud Control to enable all the databases in the configuration to be discovered as targets and to be ready to be monitored.