Online Access Free 1z0-076 Practice Test

You must configure an Oracle Data..........
1. A primary database
2. A physical standby database
Examine these requirements: 1. Data loss is not permitted.
1. Data loss is not permitted.
2. It should be possible to convert the physical standby database to a snapshot standby database.
3. Under normal operations, transactions should commit when redo is written to disk on the primary database and as soon as it has been received by the standby database instance.
4. The availability of the primary database should not be compromised by the availability of the standby database.
5. It should be possible to convert the physical standby database to a logical standby database
6. It should be possible to deploy Real Application Clusters on the primary database.
7. It should be possible to deploy Real Application Clusters on the physical standby database.
You configure SYNC redo transport mode in combination with Maximum Protection mode.

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

You have a Data Guard Broker configuration called 'Somewhere' as shown:
DGMGRL> SHOW CONFIGURATION;
Configuration - Somewhere
Protection Mode: MaxPerformance
Databases:
Nearby - Primary database
FS - Far Sync
Farout - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
You then run this command:
DGMGRL> SHOW DATABASE 'Nearby' 'InconsistentProperties';
Which two are true about the output of this DGMGRL command?

• A.Any inconsistency reported is on an instance-specific basis.
• B.It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby.
• C.It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout.
• D.A far sync instance cannot have inconsistent properties because it has no database.

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

Which TWO statements are true regarding Data Guard Broker?

• A.It can be used to create and manage standby databases.
• B.It can be used to monitor redo transport and log apply services.
• C.It automatically adds the primary database to an existing broker configuration when Enterprise Manager Cloud Control is used to create a standby.
• D.It automatically starts the DMON process for the database instances that are part of a Data Guard configuration.
• E.It can be used to perform failovers and switchovers.

Which three are true regarding prerequisites for a logical standby database as a disaster recovery solution?

• A.Ensure that no ROWID data types are contained in the primary database.
• B.Ensure that supplemental logging is enabled on the primary database.
• C.Ensure that no BFILE LOB data types are contained in the primary database.
• D.Ensure that flashback is enabled on the primary database.
• E.Do not perform any nologging operations on the primary.