Online Access Free 1Z1-066 Practice Test

You must manually reinstate a database using DGMGRL.
To which database should you connect with DGMGRL before issuing the REINSTATE command and in which state should the target database be?

• A.The target database should be MOUNTED and DGMGRL should be connected to the target database.
• B.The target database should be MOUNTED and DGMGRL should be connected to the primary database.
• C.The target database should be MOUNTED and DGMGRL should be connected to any database that is a member of the configuration.
• D.The target database should be in NOMOUNT state and DGMGRL should be connected to the primary database.
• E.The target database should be in NOMOUNT state and DGMGRL should be connected to any database that is a member of the configuration.

Which two are prerequisites for enabling Automatic Block Media Recovery in a Data Guard environment consisting of a primary database, one physical standby database and one logical standby database? (Choose two.)

• A.There must be connectivity between the primary and the physical standby database.
• B.The logical standby database must have Real-Time Query enabled.
• C.FLASHBACK DATABASE must be enabled on the primary database.
• D.The physical standby database must have Real-Time Apply enabled.
• E.FLASHBACK DATABASE must be enabled on the physical standby database.

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 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.
• 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 LOCAL_LISTENER parameter for all the database instances, to register services with the default listener on the primary database host.
• D.Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.

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 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.
• C.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.
• D.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.
• E.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.

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