Which three are true concerning archive logs in a Data Guard Environment? (Choose three.)
A. A physical standby database instance chooses an appropriate location for writing its own standby archive logs automatically.
B. A far sync instance writes to the LOG_ARCHIVE_DEST directory if the remote logical standby database instance to which it routes redo, is not reachable.
C. A far sync instance writes to the LOG_ARCHIVE_DEST directory if the remote physical standby database instance to which it routes redo, is not reachable.
D. A logical standby database instance writes online redo logs.
E. A logical standby database chooses an appropriate location for writing its own standby archive logs automatically.
F. A physical standby database instance writes online redo logs.
Which three are true about the use of the VALID_FOR clause of the LOG_ARCHIVE_DEST_N parameter, in determining whether archive logs should be written to a particular destination by a database in a Data Guard environment? (Choose three.)
A. whether the database at the destination is reached by using a far sync instance
B. whether the database at the destination is a primary or a standby
C. whether online redo logs are to be archived at a specific destination
D. whether standby redo logs are to be archived at a specific destination
E. whether the database at the source is a primary or a standby
Which three are true about disabling of the Data Guard Broker management of databases in a configuration and the effects of doing this? (Choose three.)
A. The configuration transport mode may be modified while the entire configuration is disabled from broker management.
B. Database properties may be modified when that database is disabled from broker management.
C. A standby database that is the fast start failover target, may be disabled from broker management only by using the disable database DGMGRL command.
D. The only way to disable broker management of the primary database is to use the disable configuration DGMGRL command.
E. The only way to disable broker management of a far sync instance is to use the disable configuration DGMGRL command.
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 command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.
B. The command will execute successfully only if the DG_BROKER_START initialization is set to TRUE for the PROD database instance.
C. The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START
IS TRUE for PRODSBY1.
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 PRODSBY1 standby database is automatically added to the configuration if Oracle Net connectivity to the PRODSBY1 database instance is defined on the primary host.
F. The command will execute successfully only if Oracle Net connectivity to the PROD and PRODSBY1 database instances are defined on the primary host.
Which three are true about using Flashback database through role transitions in a Data Guard environment? (Choose three.)
A. Flashback database may not be used to undo a physical standby database activation.
B. Physical standby databases retain their current role when you flash back to a point in time before a reinstate occurred which caused this database to become a physical standby.
C. Logical standby database role are reverted to their original role when you flash back to a point in time before the switchover occurred which caused this database to become a logical standby.
D. Physical standby databases retain their current role when you flash back to a point in time before the switchover occurred which caused this database to become a physical standby.
E. Logical standby databases retain their current role when you flash back through to a point in time the switchover occurred which caused this database to become a logical 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. 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.
B. 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.
C. 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.
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. 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.
Which two are true concerning the configuring of Flashback database in a Data Guard environment? (Choose two.)
A. It enables the use of far sync instances.
B. It is a prerequisite for the use of Fast Start Failover.
C. It permits a primary database that was disabled after failover to be reinstated as a standby.
D. It permits a physical standby database to be converted to a snapshot standby database.
E. It is required in order for a snapshot standby database to be converted to a physical database.
Which two statements are true about Far Sync instances? (Choose two.)
A. They work in Maximum Availability mode.
B. They work in Maximum Performance mode.
C. They work in Maximum Protection mode.
D. They do not work with Logical Standby databases.
E. They do not work with Snapshot Standby databases.
Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting.
Switchovers or failovers are possible due to testing or in case of a disaster.
Clients use local TNSNAMES.ORA files to define connection strings to the database instances.
Which three will prevent clients from connecting to the wrong database instances? (Choose three.)
A. Client TNS entries for the databases use the correct service names for the intended service.
B. A service name is registered with the local listener of each database instance.
C. Oracle Net connectivity to the primary database instance must be established on all the standby database instances.
D. The LOCAL_LISTENER parameter on the primary database instance must always be set.
E. The standby database services must be defined statically with the Listeners running on the standby database hosts.
F. The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment.
G. The client applications must use the correct TNS entries when requesting connections to the database instances.
Which two steps must be performed before running DUPLICATE TARGET DATABASE FOR STANDBY using RMAN? (Choose two.)
A. Transfer a copy of the passwordfile from the primary host to the standby host.
B. Run the nid utility to modify the DBID of the primary database.
C. Create an SPFILE for the standby database.
D. Configure Oracle Net connectivity between the primary host and the standby host.
E. Create a standby controlfile.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-066 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.