Which three are true concerning database states after a successful switchover? (Choose three.)

• A.If the former primary database became a logical standby database it will be in mount state.
• B.The new primary database will be open read-write.
• C.The former primary database will always be open.
• D.If the former primary database became a logical standby database it will be open read-write.
• E.If the former primary database became a physical standby database it will always be open read-only.
• F.If the former primary database became a physical standby database it will be in the same state as the former physical standby database.

Comment: *

Name: *

Email: *

Verification: *

Which three are among the various tasks performed by the data Guard Monitor (DMON) process?

• A.performing role transitions when switchover requests are made
• B.communicating with DMON processes in other database instances that are part of the broker configuration
• C.activating role-based services appropriately in the various database instances of the configuration, based on the database role
• D.communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required.
• E.maintaining information about all members of the broker configuration in binary configuration files

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about snapshot standby databases? (Choose three.)

• A.Tablespaces can be dropped.
• B.Tables can be dropped.
• C.The broker may be used to fail over to a snapshot standby database.
• D.A logical standby database can be converted into a snapshot standby database.
• E.Tablespaces can be created.

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"
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;
• C.DGMGRL> convert database sheep to physical standby;
  DGMGRL> convert database cats to physical standby;
• D.DGMGRL>edit configuration set protection mode as maxperformance;
  DGMGRL> convert database sheep to physical standby;
• E.None, because you can directly failover to a Snapshot Standby Database.

Comment: *

Name: *

Email: *

Verification: *

Your Data Guard environment consists of these components and settings:
1. A primary database
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.
You notice that queries executed on the physical standby database receive errors:
ORA- 03172: STANDBY_MAX_DATA_DELAY of 15 seconds exceeded.
Which two would you recommend to avoid this error? (Choose two.)

• A.Change the protection mode to Maximum Performance.
• B.Increase the size of the buffer cache on the standby database instance.
• C.Reduce I/O latency for the storage used by the primary database.
• D.Change the protection mode to Maximum Protection.
• E.Increase the network bandwidth between the primary and standby databases.
• F.Increase the number of standby redo log files on the primary database.

Comment: *

Name: *

Email: *

Verification: *