oracle 1z0-066 practice test

Oracle Database 12c: Data Guard Administrator Exam


Question 1

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. It simplifies physical standby database creation.
  • A. The configuration transport mode may be modified while the entire configuration is disabled from broker management.
  • B. It provides an easy failover capability using a single command.
  • B. Database properties may be modified when that database is disabled from broker management.
  • C. It coordinates database state transitions and updates database properties dynamically.
  • 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. It automatically changes database properties after the protection mode for a configuration is changed.
  • D. The only way to disable broker management of the primary database is to use the disable configuration DGMGRL command.
  • E. It provides an easy switchover capability using a single command.
  • E. The only way to disable broker management of a far sync instance is to use the disable configuration DGMGRL command.
  • F. It simplifies logical standby database creation.
  • G. It load balances connections between the primary and all the standby database instances that are open as read-only for reporting.
Answer:

B,C,D

Discussions

Question 2

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. The leading group contains the original primary database.
  • A. whether the database at the destination is reached by using a far sync instance
  • B. The trailing group contains the original primary database.
  • B. whether the database at the destination is a primary or a standby
  • C. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process.
  • C. whether online redo logs are to be archived at a specific destination
  • D. At least one logical standby database must be part of the initial Data Guard configuration.
  • D. whether standby redo logs are to be archived at a specific destination
  • E. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process.
  • E. whether the database at the source is a primary or a standby
Answer:

A,D,E

Discussions

Question 3

Which three are true concerning archive logs in a Data Guard Environment? (Choose three.)

  • A. It succeeds only if SQL apply is stopped before deleting the SQL Apply filter.
  • A. A physical standby database instance chooses an appropriate location for writing its own standby archive logs automatically.
  • B. It succeeds but the SQL Apply filters are not deleted.
  • 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. It deletes both the SQL Apply filters.
  • 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. It returns an error because the syntax to delete a SQL Apply filter must specify the same object names as specified when the filter was added.
  • D. A logical standby database instance writes online redo logs.
  • E. It succeeds only if all DML statements executed on the primary have been applied on the logical standby deleting the SQL Apply filter.
  • 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.
Answer:

A,C,E

Discussions

Question 4

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. They are required on a logical standby for real-time apply.
  • 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. They are required only for synchronous redo transport.
  • 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. Only standby databases can write redo to them.
  • 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. It is recommended to have them on the primary database.
  • 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. They are required on a physical standby for real-time apply.
  • 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.
  • F. The LGWR process writes to them on a standby database.
Answer:

E

Discussions

Question 5

Which three are true about using Flashback database through role transitions in a Data Guard
environment? (Choose three.)

  • A. 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.
  • A. Flashback database may not be used to undo a physical standby database activation.
  • B. Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby.
  • 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. 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.
  • 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. Set the LOCAL_LISTENER parameter for all the database instances, to register services with the default listener on the primary database host.
  • 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.
Answer:

B,C,D

Discussions

Question 6

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. 2, 3, 4, and 5
  • A. The command will execute successfully only if Oracle Net connectivity to the PROD database instance is defined on the primary host.
  • B. 1, 2, 3, 4, and 5
  • B. The command will execute successfully only if the DG_BROKER_START initialization is set to TRUE for the PROD database instance.
  • C. 1 and 2
  • C. The PRODSBY1 standby database is automatically added to the configuration if DG_BROKER_START IS TRUE for PRODSBY1.
  • D. only requirement 5
  • 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. only requirement 1
  • 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.
Answer:

C,D,E

Discussions

Question 7

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. 1, 2, and 3
  • A. Client TNS entries for the databases use the correct service names for the intended service.
  • B. 2 and 5
  • B. A service name is registered with the local listener of each database instance.
  • C. 1 and 5
  • C. Oracle Net connectivity to the primary database instance must be established on all the standby database instances.
  • D. 1, 2, 3, 4, and 5
  • D. The LOCAL_LISTENER parameter on the primary database instance must always be set.
  • E. 1, 2, and 4
  • E. The standby database services must be defined statically with the Listeners running on the standby database hosts.
  • F. 2, 3, and 5
  • 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.
Answer:

C,D,G

Explanation:
References:
https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/configuring-data-guard-standby-databases-in-oracle-RAC.html#GUID-65F87F2F-6602-4673-B971-4AEE3B4F7B4D
https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG010
https://docs.oracle.com/cd/E11882_01/network.112/e41945/concepts.htm#NETAG177

Discussions

Question 8

Which two statements are true about Far Sync instances? (Choose two.)

  • A. Cats is a snapshot standby database.
  • A. They work in Maximum Availability mode.
  • B. The redo transport mode is set to ASYNC for the standby database Sheep.
  • B. They work in Maximum Performance mode.
  • C. The redo transport mode is set to ASYNC for both standby databases.
  • C. They work in Maximum Protection mode.
  • D. The redo transport mode is set to ASYNC for the standby database Cats.
  • D. They do not work with Logical Standby databases.
  • E. They do not work with Snapshot Standby databases.
Answer:

A,C

Explanation:
far sync instance is supported in either maximum performance or maximum availability mode.
Usually when Data Guard is running under maximum availability and there is chance to switch
internally to maximum performance in case of redo data unable to commit on any one standby
database, With the same mechanism Oracle can work on both maximum availability and maximum
performance, so worth increasing the protection level to Maximum availability.

Discussions

Question 9

Which two are true concerning the configuring of Flashback database in a Data Guard environment?
(Choose two.)

  • A. Fast-Start Failover is not yet enabled for this Data Guard configuration.
  • A. It enables the use of far sync instances.
  • B. The observer configuration file is marked read-only.
  • B. It is a prerequisite for the use of Fast Start Failover.
  • C. There is already an observer running for this Data Guard configuration.
  • C. It permits a primary database that was disabled after failover to be reinstated as a standby.
  • D. There is another observer running for a Data Guard configuration which uses the same observer configuration file.
  • D. It permits a physical standby database to be converted to a snapshot standby database.
  • E. The broker configuration has not yet been created.
  • E. It is required in order for a snapshot standby database to be converted to a physical database.
Answer:

A,B

Explanation:
References:
https://docs.oracle.com/database/121/SBYDB/create_fs.htm#SBYDB5416
https://logicalread.com/2013/10/01/increasing-oracle-availability-with-fast-start-failover-mc04/

Discussions

Question 10

Examine this command executed on a physical standby database to transition it to a logical standby
database:
SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY prodlgsby;
Which statement is true regarding the execution of this command?

  • A. A flash recovery area must be configured.
  • A. FLASHBACK is automatically enabled when transitioning to the logical standby database.
  • B. The database must be in MOUNT state.
  • B. The Managed Recovery Process (MRPO) continues applying redo up to the SCN immediately preceding the redo corresponding to the LogMiner dictionary build.
  • C. The database must be in ARCHIVELOG mode.
  • C. Supplemental logging will be enabled on the logical standby database when the physical database is transitioned to the logical standby database.
  • D. A far sync instance must be configured to flash back a standby when the primary has been flashed back.
  • D. SQL apply is automatically started when transitioning to the logical standby database.
  • E. The Data Guard Broker must be used.
  • E. It will automatically start redo apply.
Answer:

E

Discussions
To page 2