Free Oracle 1z0-076 Exam Dumps Questions & Answers

Active Data Guard (ADG) databases are widely used to offload reporting or ad hoc query-only jobs from the primary database. Reporting workload profile is different from the primary database and often requires tuning.
Which tool is used to tune SQL workloads running on an ADG database?

• A.Automatic Workload Repository (AWR)
• B.SQL Tuning Advisor
• C.In-Memory Active Session History (ASH)
• D.Automatic Diagnostic Database Monitor (ADDM)
• E.Standby Statspack

The Oracle database 19c Observer is currently running on host1 and you wish to have it running on host2.
Examine this list of possible steps:
1) Stop the observer on host1
2) Disable Fast-Start Failover
3) Update the broker configuration with the new observer hostname
4) Enable Fast-Start Failover
5) Start the Observer on host2
Which contains the minimum required steps to move the observer to host2?

• A.Execute only task 5
• B.Execute tasks 1 and 5
• C.Execute tasks 1, 3, and 5
• D.Execute tasks 1, 2, 3, 4, and 5

Which TWO statements are true about database parameters for databases in a Data Guard environment?

• A.COMPATIBLE must have identical values for primary and standby databases.
• B.DB_FILE_NAME_CONVERT is only required if the standby database is on the same host as the primary database.
• C.The databases that are part of a Data Guard configuration must have different DB_UNIQUE_NAME initialization parameters.
• D.LOG_FILE_NAME_CONVERT applies to online redo logs and archived logs.
• E.If DB_RECOVERY_FILE_DEST is specified, then LOG_ARCHIVE_DEST_n is not required for local archive logs.

Which TWO are benefits of using Transaction Guard in a Data Guard environment?

• A.It protects against logical corruptions being replicated to standby databases.
• B.It provides application continuity by replaying transactions interrupted by a failover or a switchover
• C.It protects against recoverable errors during a planned or an unplanned outage of a primary database.
• D.It provides application continuity by rolling back uncommitted transactions interrupted by a failover or switchover.
• E.It protects against user errors being replicated to standby databases.

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