Try and practice the latest Oracle : 1z1-076 real questions & answers

Your Data Guard environment contains a primary database and three standby databases with these attributes:
1. prod : Primary database
2. prod_prq : Physical standby database with real-time query enabled used by reporting applications
3. prod_lsby: Logical standby database used by DSS
4. PROD_SSBY: Snapshot standby database used for Real Application Testing Which TWO can be used to prevent clients from connecting to the wrong database instance?

• A. Establish Oracle Net connectivity to the primary database instance from all the standby database instances.
• B. Create database services on each of the standby databases, start the services, and add connection descriptors on the clients to connect to those services.
• C. Create database services for each database and use event triggers to make sure that services are activated only when the database is in the correct role.
• D. Create a static service for each of the databases, register it with the local listener of each database instance, and add connection descriptors on clients to connect to those services.
• E. Create role based services with the si vet] utility when using clusterware for Oracle RAC databases or Oracle Restart for single instance Oracle databases.

Examine this list of possible steps:
1. Raise the compatibility level on both databases.
2. Restart SQL Apply on the upgraded logical standby database.
3. Start SQL Apply on the old primary database.
4. Perform a Switchover to the logical standby database.
5. Upgrade the logical standby database.
6. Upgrade the old primary database.
Which is the minimum number of steps in the correct order, to perform a rolling release upgrade of a data guard environment using an existing logical standby database and to enable the new functionality?

• A. 5,2,4,1
• B. 4,6,5,2,3,1
• C. 5,2,4,6,3,1
• D. 5,2,4,3,6,1
• E. 1,5,2,4,6,3

Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database?

• A. It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database.
• B. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database.
• C. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database.
• D. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered.
• E. Primary and physical standby databases may use different virtual recovery catalogs in the same physical recovery catalog.

Attempting to start the observer raises an error:
DGMGRL> start observer;
DGM-16954: Unable to open and lock the Observer configuration file
Failed.
Identify two possible ways to start the observer successfully.

• A. Create a broker configuration and enable Fast-Start Failover before starting the observer.
• B. Enable Fast-Start Failover before starting the observer.
• C. Start the observer in a different working directory.
• D. Set the ObserverOverride property to TRUE before starting the observer.
• E. Start the observer using a different observer configuration file.

You created a physical standby database prodsbyi from the primary database prod using SQL and RMAN. Which THREE are prerequisites for creating a Data Guard Broker configuration to manage these databases?

• A. The standby database must have supplemental logging enabled.
• B. The DG_BROKER_START parameter must be set to TRUE for both database instances.
• C. The LOG_ARCHIVE_DEST_n parameters with the service attribute set must be cleared.
• D. A local net service name to enable connectivity to the PRODSBYI database instance must be defined on the primary database host.
• E. The primary database must have supplemental logging enabled.
• F. The primary database must have FORCE LOGGING enabled.