Tuesday 31 July 2018

Oracle 1z0-066 Question Answer

After converting your physical standby database to a logical database, you get an error:
DGMGRL> show configuration
Configuration- proddg
Protection Mode: MaxPerformance
Databases:
prod-Primary datatabse
prodsby-Physical standby database
Error: ORA-16810 multiple errors or warnings detected for database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
How can you rectify the error?


A. Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.
B. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it.
C. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration.
D. Reinstate both the primary and physical standby databases. The broker will automatically detect that PRODSBY is a logical standby update to the metadata.

Answer: D


Which four requirements can be met by deploying a logical standby database?


A. Support for workloads requiring additional indexes.
B. It can be used to create additional schemas.
C. It can be used to create additional tables.
D. It must have the same physical structure as the primary database.
E. it must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers.
F. Support for workloads requiring additional materialized views.
G. It can be used for Real Application Testing without affecting the disaster recovery capabilities.

Answer: ACEG