Free Oracle 1z1-076 Exam Dumps Questions & Answers

Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration?

• A.  The LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance.
• B.  A TNS entry enabling connectivity to the primary database instance must be defined on each of the standby database hosts.
• C.  A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host.
• D.  To start SQL Apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host.
• E.  To enable Real-Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host.

Your Data Guard environment has two remote physical standby databases.
Client applications use the local naming method to connect to the primary database instance.
You want applications to automatically connect to the new primary database instance in case of a switchover or a failover.
Which set of actions will fulfill this requirement?

• A.  Set the LOCAL_LISTENER parameter for all the database instance to register services with the default listener on the primary database host.
• B.  Set the INSTANCE NAME parameter identically on all databases; modify the connection descriptor on client applications to include all the standby hosts and connect to the database instance using that service name.
• C.  Set DB_NAME and DB_UNIQUE_NAME identically on all databases; modify the connection descriptors on client applications to include all the standby hosts and connect to the database instance using that service name.
• D.  Create a database service on the primary database that is started automatically by a trigger, when the database role is PRIMARY; modify the connection descriptors used by client applications to include all the standby hosts and connect to the database instance using that service name.

Which THREE are among the various tasks performed by the Data Guard Monitor (DMON) process?

• A.  communicating with dkon processes in other database instances that are part of the broker configuration
• B.  performing role transitions when switchover requests are made
• C.  activating role-based services appropriately in the various database instances of the configuration, based on the database role
• D.  communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required
• E.  maintaining information about all members of the broker configuration in binary configuration files.

A customer has these requirements for their proposed Data Guard implementation:
1. Zero data loss must still be guaranteed through the loss of any one configuration component.
2. The primary database must be protected against a regional disaster.
3. Performance overheads on the primary should be minimized as much as possible given these requirements.
4. Downtime on the primary database for any reason must be kept to a minimum.
Components referred to in the broker commands are:

• A. 
• B. 
• C. 
• D. 

Which TWO statements are true about Far Sync instances?

• A.  They work in Maximum Protection mode.
• B.  They do not work with Snapshot Standby databases.
• C.  They work in Maximum Availability mode.
• D.  They do not work with Logical Standby databases.
• E.  They work in Maximum Performance mode.