Which two are true about management of a far sync instance when using the Data Guard Broker?

A. A far sync instance is in a disabled state in the broker configuration immediately after adding it

B. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration.

C. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command.

D. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created

Which four database parameters might be affected by or influence the creation of standby databases?

A. DB_NAME

B. ARCHIVE_LAG_TARGET

C. COMPATIBLE

D. DB_FILE_NAME_CONVERT

E. DB_UNIQUE_NAME

F. FAL_SERVER

G. STANDBY_ARCH1VE_DEST

You must propose an Oracle Data Guard configuration tor a database supporting an OLTP workload that meets these permanent 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 designated 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 standby database configured in Maximum Protection mode.

Which requirements do you meet?

A. 2,3, 4, and 5

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

C. 1 and 2

D. only requirement 5

E. only requirement 1

Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

A. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.

B. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.

C. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.

D. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.

E. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog

Examine the Data Guard configuration: DGMGRL> show configuration Configuration -Animals Protection Mode: MaxAvailability Databases: dogs- Primary database sheep- (*) Physical standby database

cats- Physical standby database Fast-Start Failover: ENABLED Configuration Status: SUCCESS What happens if you issue "switchover" to sheep;" at the DGMGRL prompt?

A. The switchover succeeds but Dogs need to be reinstated

B. The switchover succeeds but Fast-Start Failover is suspended.

C. The switchover succeeds and Cats become the new failover target.

D. The switchover succeeds and Dogs become the new failover target

E. it results in an error indicating that a switchover is not allowed.

Which two are true about database roles in an Oracle Data Guard Configuration?

A. a configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade.

B. A Logical Standby Database can be converted to a Snapshot Standby Database.

C. A Logical Standby Database can cascade redo to a terminal destination

D. A Snapshot Standby Database can be a fast-start failover target

E. A Physical Standby Database can be converted into a Logical Standby Database.

Which two are true about rolling release upgrades in a Data Guard environment?

A. The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure

B. A physical standby database can be converted to a logical standby database temporarily.

C. Rolling release upgrades require the background process RVWR to write flashback logs on the standby database.

D. The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database.

E. The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure.

Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled?

A. if the CACHE option is set then the size of the cache must be at least 100

B. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary

C. Their usage will always have a performance impact on the primary database.

D. Their usage may have a performance impact on the physical standby database if the CACHE size is too small

E. They must have the NOORDER and CACHE options set.

Your Data Guard environment consists of these components and settings:

1.

A primary database

2.

Two remote physical standby databases

3.

The redo transport mode is set to SYNC.

4.

Real-time query is enabled for both standby databases.

5.

The DB_BLOCK_CHECKING parameter is set to TRUE on both standby databases.

You notice an increase in redo apply lag time on both standby databases.

Which two would you recommend to reduce the redo apply lag on the standby databases?

A. Increase the size of the buffer cache on the physical standby database instances.

B. Increase the number of standby redo log files on the standby databases.

C. Decrease the redo log file size on the primary database.

D. Lower DB_BLOCK_CHECKING to MEDIUM or LOW on the standby databases.

E. Increase the size of standby redo log files on the standby databases.

You must propose an Oracle Data Guard configuration for a database supporting a DSS workload that meets these permanent 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 the 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 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 configuration operating in Maximum Performance mode with a primary database and one logical standby database.

Which requirements do you meet?

A. 1, 2, and 3

B. 2 and 5

C. 1 and 5

D. 1, 2, 3, 4, and 5

E. 1, 2, and 4

F. 2, 3, and 5