Question 1

Which configuration option is required to enable Oracle Active Data Guard for read-only standby databases?

Options :

A :

Snapshot Standby

B :

Redo Apply

C :

SQL Apply

D :

Logical Standby

Answer: C

Question 2

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

Options :

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

What happens to the redo logs on the physical standby database during the process of redo apply?

Options :

A :

They are copied to the FRA (Fast Recovery Area) on the standby database.

B :

They are automatically deleted after being applied to the standby database.

C :

They are archived to the configured archival destination on the standby database.

D :

They are overwritten with new redo data from the primary database.

Answer: B

Question 4

You must propose an Oracle Data Guard configuration for a database supporting an OLTP workload that meets these permanent requirements:

Data loss is not permitted.

Read-only applications should not connect to the primary database instance.

Additionally, there are these requirements, only one of which is ever done at any one time:

It should be possible to apply and test designated patches with a minimum amount of downtime.

Upgrading to a new database release should be performed with the least possible amount of downtime.

New application software releases should be tested against an exact up-to-date replica of the production database.

You propose a primary database with one physical standby database configured in Maximum Protection mode. Which requirements do you meet?

Options :

A : 1 and 2

B : 1, 2, 3, 4, and 5

C : Only requirement 5

D : Only requirement 1

E : 2, 3, 4, and 5

Answer: D

Question 5

Which command is used to enable or disable Fast-Start Failover in Oracle Data Guard?

Options :

A :

ALTER BROKER

B :

ALTER DATABASE

C :

ALTER SYSTEM

D :

ALTER SESSION

Answer: A

Confidently Practice Online with Free 1Z0-076 Exam Cram

Buying Options: