Your Data Guard environment consists of these components and settings:
1. A primary database supporting an OLTP workload
2. A remote physical standby database
3. Real-time query is enabled
4. The redo transport mode is set to SYNC.
5. The protection mode is set to Maximum Availability.
Which two are true regarding the DelayMins Database Property for the standby database? (Choose two.)

• A.It can only be enabled for a configuration in Maximum Performance mode.
• B.It allows user errors on the primary to be recovered by using the physical standby database.
• C.It enables you to bypass the default network timeout interval specified for the standby redo transport destination.
• D.It can only be enabled for a configuration in Maximum Availability mode.
• E.It allows logical corruptions on the primary to be recovered by using the physical standby database.
• F.It specifies a delay before the primary ships redo to the standby destination having DelayMins set.

Comment: *

Name: *

Email: *

Verification: *

You administer a Data Guard environment consisting of a primary and three physical standby databases.
One physical standby database is used for disaster recovery, one is used for reporting, and one is used as a replica for testing.
The standby database used for testing is occasionally converted into a snapshot standby database and then converted back to a physical standby.
The physical standby database is the only standby that is a mandatory destination.
The broker configuration operates in MAXIMUM PERFORMANCE mode.
Which ARCHIVELOG DELETION POLICY should be set, so that archive logs generated on the primary database are not deleted before they are consumed appropriately on each of the standby databases, but which allows them to be deleted form the primary as soon as it is safe to do so?

• A.CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
• B.CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
• C.CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;
• D.CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;
• E.CONFIGURE ACHIVELOG DELETION POLICY TO NONE;

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Data Guard database modes and states? (Choose three.)

• A.A primary database may ship redo directly to more than mine standby databases.
• B.Force Logging Mode is not required for a primary database but is recommended.
• C.A Logical Standby Database can be in MOUNTstate while applying changes.
• D.The Primary Database can operate in noarchivelogmode.
• E.Databases in a Data Guard Configuration need not operate in Flashback Logging mode.

Comment: *

Name: *

Email: *

Verification: *

Which three types of backups taken in which situations may be used to perform restore operations to a logical standby database in a Data Guard environment?

• A.backups of control files taken on the primary database if connected to the recovery catalog where the logical standby database is registered
• B.backups of data files taken on the standby database if connected to the recovery catalog where the logical standby database is registered
• C.backups of control files taken on the logical standby database if not connected to a recovery catalog
• D.backups of data files taken on the logical standby database, if not connected to a recovery catalog
• E.backups of data files taken on the primary database if connected to the recovery catalog where the logical standby database is registered

Comment: *

Name: *

Email: *

Verification: *

Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which will fulfill this requirement?

• A.Create a database service on each standby database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
• B.Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.
• C.Set the INSTANCE_NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.
• D.Set the DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.

Comment: *

Name: *

Email: *

Verification: *