Question 1

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

Options :

A :

Oracle Clusterware

B :

Data Guard Broker

C :

Oracle Net Services

D :

Fast Application Notification (FAN)

Answer: D

Question 2

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?

Options :

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 3

What are the different types of Data Guard databases?

Options :

A :

Physical Standby, Logical Standby, and Active Data Guard

B :

Physical Standby, Logical Standby, and Flashback Standby

C :

Physical Standby, Snapshot Standby, and Flashback Database

D :

Physical Standby, Snapshot Standby, and Active Data Guard

Answer: A

Question 4

What is the purpose of the MRP (Managed Recovery Process) in a physical standby database?

Options :

A :

To apply redo data received from the primary database.

B :

To perform automated backups of the standby database.

C :

To monitor the health and availability of the standby database.

D :

To manage the network configuration of the standby database.

Answer: A

Question 5

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

Options :

A :

ENABLE_SNAPSHOT_STANDBY

B :

ENABLE_DGMGRL_SNAPSHOT

C : DB_RECOVERY_FILE_DEST

D :

STANDBY_ARCHIVE_DEST

Answer: A

Free 1Z0-076 Mock Exam – Practice Online Confidently

Buying Options: