Online Access Free 1Z1-066 Exam Questions

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

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

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 database
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.Reinstate the physical standby database PRODSBY as a logical standby, 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 both the primary and physical standby databases. The broker will automatically detect that PRODSBY is a logical standby update to the metadata.
• D.Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration.

Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard? (Choose three.)

• A.It modifies the database configurable parameters to match the values set for the broker configuration.
• B.It checks that the current data protection level is consistent with the broker's configured data protection mode.
• C.It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database.
• D.It checks that supplemental logging is turned on if there is a logical standby database in the configuration.
• E.It verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database.

You created the PRODSBY1 physical standby database for the PROD primary database using SQL and RMAN.
You are planning to create a Data Guard Broker configuration.
You execute the command:
DGMGRL> CREATE CONFIGURATION 'DGConfig' AS
> PRIMARY DATABASE IS 'PROD'
> CONNECT IDENTIFIER IS PROD;
Which three statements are true regarding the execution of the command? (Choose three.)

• A.The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START IS TRUE for PRODSBY1.
• B.The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.
• C.The command will execute successfully only if the DG_BROKER_START initialization is set to TRUE for the PROD database instance.
• D.The Data Guard Broker configuration files is automatically created in the destinations specified by the DG_BROKER_CONFIG_FILEn initialization parameters on the primary database.
• E.The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBY1 database instances are defined on the primary host.
• F.The PRODSBY1 standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBY1 database instance is defined on the primary host.

Which three statements are true about Data Guard configurations? (Choose three.)

• A.VALID_FOR is a LOG_ARCHIVE_DEST_N attribute that enables DB role change operations without having to modify LOG_ARCHIVE_DEST_n when performing switchovers or failovers.
• B.All databases in one Data Guard environment must have the same database name.
• C.For Standard Edition, LOG_ARCHIVE_DUPLEX_DEST is used to configure redo transport, from the primary to the standby database.
• D.When using the Data Guard Broker, an spfile is not required.
• E.Up to 30 physical standby databases may exist within one configuration.
• F.The Oracle recommendation for the number of standby redo log groups per thread is one more than the number of online redo log groups per thread.