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.

Comment: *

Name: *

Email: *

Verification: *

A Data Guard environment has this configuration and these attributes:
1. A primary database
2. A Physical Standby Database named sbdb
3. The configuration is in maximum availability protection mode.
Then sbdb is converted to a snapshot standby database.
When two statements are true? (Choose two.)

• A.Sdbd can still apply redo.
• B.The recovery point objective increases.
• C.The protection mode is lowered to maximum performance.
• D.The recovery time objective increases.
• E.Sbdb can still receive redo

Comment: *

Name: *

Email: *

Verification: *

Examine the Data Guard configuration:
DGMGRL> show configuration;
Configuration -Animals Protection Mode MaxAvailability
Databases
dogs- Primary database
cats- Snapshot standby database
sheep- Snapshot standby database
Fast-Start Failover DISABLED
Configuration Status: ORA-01034: ORACLE not available ORA-16625: cannot reach database "dogs'1
DGM-17017 unable to determine configuration status
You wish to perform a failover to Sheep
Which command, or sequence of commands, should you issue to the broker before executing "failover to
sheep", using the broker?

• A.DGMGRL> convert database cats to physical standby,
• B.DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical
  standby;
• C.None, because you can directly failover to a Snapshot Standby Database
• D.DGMGRL> convert database sheep to physical standby;
• E.DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database
  sheep to physical standby;

Comment: *

Name: *

Email: *

Verification: *

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

• A.Their usage may have a performance impact on the physical standby database ifthe CACHE size is too
  small
• B.Their creation requires that a LOG_ARCH IVE_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.if the CACHE option is set then the size ofthe cache must be at least 100
• E.They must have the NOORDER and CACHE options set.

Comment: *

Name: *

Email: *

Verification: *

Which three factors can influence the rate of redo apply on a physical standby database?

• A.the number of archiver processes on the standby database
• B.the rate of redo generation on the primary database
• C.the number and size of standby redo logs on the standby database
• D.the network latency between the primary and standby databases
• E.the number and size of standby redo logs on the primary database

Comment: *

Name: *

Email: *

Verification: *