Online Access Free 1Z0-066 Practice Test

Examine the Data Guard configuration:
DGMGRL> show configuration:
Configuration Animals
Protection Mode: MaxAvailability
Databases:
dogs Primary database
sheep Logical standby database
cats Logical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Sheep? (Choose three.)

• A.Dogs will be a logical standby database.
• B.Cats will be an enabled logical standby database.
• C.Cats will be a disabled logical standby database.
• D.Sheep will be the primary database.
• E.Dogs will be a physical standby database.

Examine the Data Guard configuration after an accidental switchover to Sheep:
DGMGRL> show configuration;
Configuration Animals
Protection Mode: MaxAvailability
Databases:
sheep Primary database
dogs Logical standby database
cats Physical standby database (disabled)
ORA-16795: the standby database needs to be re-created
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Which three will be true after a switchover to Dogs? (Choose three.)

• A.Sheep will be an enabled logical standby database.
• B.Cats will be an enabled physical standby database.
• C.Cats will be a disabled physical standby database that can be manually enabled.
• D.Sheep will be a disabled logical standby database.
• E.Dogs will be the primary database.

You have a Data Guard broker configuration consisting of:
1. A primary database
2. One local physical standby database
3. One far sync instance
4. A remote physical standby database
The broker configuration was created with the DGMGRL utility after creating all the databases and the far sync instance with command-line tools.
What is the correct way to add this configuration to Enterprise Manager Cloud Control assuming all the nodes have been discovered already as Enterprise Manager targets?

• A.Delete the Data Guard Broker configuration using DGMGRL and then re-create it using Enterprise Manager Cloud Control to enable all the databases in the configuration to be discovered as targets and to be ready to be monitored.
• B.Discover either of the physical standby databases as a target by refreshing the node on which they run, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.
• C.Use the DGMGRL utility to register the configuration with the Enterprise manager Cloud Control agent on the primary database node. This will enable the discovery of all the other databases in the configuration as targets which will be ready to be monitored.
• D.Discover the primary as a target by refreshing the node on which it runs, and the other databases and instances in the Data Guard Broker configuration will be discovered as targets automatically and be ready to be monitored.
• E.Discover the primary database as a target in Enterprise Cloud Control. Then discover the existing Data Guard Broker configuration for the primary and all the other databases in the configuration will be discovered as targets and be ready to be monitored.

Which two statements are true regarding Data Guard Broker? (Choose two.)

• A.It can be used to create and manage standby databases.
• B.It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.
• C.It can be used to monitor redo transport and log apply services.
• D.It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
• E.It can be used to perform failovers and switchovers.

Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to define connectivity to the primary database instance.
Which will automatically redirect clients to the new primary database in case of a switchover or failover?

• A.Set the LOCAL_LISTENER parameter for all the database instances, to register services with the default listener on the primary database host.
• B.Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection description on the clients to use that service.
• C.Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance.
• D.Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.