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 is this scenario?

（含图）

How you can rectify the error?

1. A primary database

2. Two physical standby databases

Examine these requirements:

1. Data loss is not permitted.

2. It should be possible to convert either of the physical standby databases to a snapshot standby database.

3. Under normal operations, transactions should not commit before redo is written to disk on both the primary database and at least on one standby database.

4. The availability of the primary database should not be compromised by the availability of the standby databases.

5. It should be possible to enable fast-start failover.

6. It should be possible to deploy Real Application Clusters on all databases.

You configure FASTSYNC redo transport mode to both standby databases in combination with Maximum Availability mode.

Which requirements will you meet

1. A primary database

2. A physical standby database

3. A snapshot standby database

You must meet these requirements:

1. A primary database availability should not be compromised by the availability of the standby databases.

2. Under normal operations, transactions executed on the primary database should not commit before redo is written to disk on

the primary database and on at least one standby database.

Which redo transport mode and which protection mode would you configure to meet these requirements?

1. A primary database

2. A physical standby database

Examine these requirements:

1. Data loss is not permitted.

2. It should be possible to convert the physical standby database to a snapshot standby database.

3. Under normal operations, transactions should commit when redo is written to disk on the primary database and as soon as it

has been received by the standby database instance.

4. The availability of the primary database should not be compromised by the availability of the standby database.

5. It should be possible to convert the physical standby database to a logical standby database.

6. It should be possible to deploy Real Application Clusters on the primary database.

7. It should be possible to deploy Real Application Clusters on the physical standby database.

You configure SYNC AFFIRM redo transport mode in combination with Maximum Protection mode.

Which requirements will you meet?

requirements:

1. Data loss is not permitted.

2. 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:

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

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

5. 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 database configured in Maximum Protection mode.

Which requirements to you meet?

requirements:

1. The performance impact on the primary database should be kept to a minimum.

2. Creating and maintaining materialized views should not impact the performance of the primary database.

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

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

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

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

You propose a configuration operating in Maximum Performance mode with a primary database and one logical standby

database.

Which requirements do you meet?

1. Creating and maintaining bitmap indexes should not impact the performance of the primary database.

2. Creating and maintaining materialized views should not impact the performance of the primary database.

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

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

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

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

Which configuration meets these requirements with the fewest of databases?

What is the significance of the COMMIT_OUTCOME attribute in this command

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 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 the Enterprise Manager Cloud Control assuming all the nodes have been

discovered already as Enterprise Manager targets?

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 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 the Enterprise Manager Cloud Control assuming all the nodes have been

discovered already as Enterprise Manager targets?

What happens if you issue “failover to dogs;” at the DGMGRL prompt while connected to Dogs?

1. A primary database containing no abstract data types used for user tables

2. Two separate remote physical standby databases used for reporting

Examine these requirements for adding a new standby database to this Data Guard environment:

-The new standby database must provide a disaster recovery solution.

- There must be minimal additional performance overheads on the primary database.

-The new standby database may require additional indexes and materialized views not present in the primary.

-New tables or schemas may be required in the standby database that are not present in the primary.

What would you recommend to fulfill these requirements?

1. We plan a Data Guard Configuration with one primary and one standby database to protect against any regional disaster.

2. It is very important that there be no significant performance impact on the primary database.

3. Reports and backups must be offloaded to the standby database.

Which recommendation would you make?

What is true concerning this configuration?

database whose SID is PROD_SBY.

Examine the command executed on a node of the primary database cluster to create a service OLTPWORKLOAD that the

applications will use to connect to the database when it is in the PRIMARY database role:
（含图）

The service is then started.

Consider this list of tasks:

1. On a node of the standby database cluster execute:

Srvctl add service -db PROD_SBY -service oltpworkload -role PRIMARY -failovertype SESSION -failovermethod BASIC -failoverdalay

10 -failoverretry 150

2. On the primary database, create the OLTPWORKLOAD database service using the DBMS_SERVICE.CREATE_SERVICE procedure.

3. Configure TAF for clients in the tnsnames.ora files.

4. Make sure clients use the OLTPWORKLOAD service to connect to the database instances.

5. On the standby database, create the OLTPWORKLOAD database service using the DBMS_SERVICE.CREATE_SERVICE procedure.

Identify the required steps to configure and use Transparent Application Failover (TAF).

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?