Free Access Oracle.1z1-076.v2025-10-15.q59 Practice Test (Page 13)

Question 56

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 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.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.

Question 57

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

A.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.

B.Logical standby databases retain their current role when you flash back through to a point in time before the switchover occurred which caused this database to become a logical standby.

C.Flashback database may not be used to undo a physical standby database activation.

D.Logical standby database roles 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.

E.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.

Question 58

Which two are prerequisites for configuring Transaction Guard in a Data Guard environment?

A.Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE.

B.Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners.

C.Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.

D.Set INSTANCE_NAME identically on all the Data Guard Configuration databases and modify the local service name on the client to include a CONNECTION_LIST containing all the standby hosts.

E.Create a database service with COMMIT_OUTCOME set to TRUE and ensure that the service is statically registered with the default listener on the primary host.

Question 59

A Data Guard environment has this configuration and these attributes:
A primary database
A physical standby database named sbdb
The configuration is in maximum availability protection mode.
Then sbdb is converted to a snapshot standby database.
Which two statements are true?

A.sbdb can still apply redo.

B.The recovery time objective increases.

C.The protection mode is lowered to maximum performance.

D.sbdb can still receive redo.

E.The recovery point objective increases.

Latest Upload: 147Huawei.H12-831_V1.0.v2025-10-16.q126; 106SAP.C-THR70-2411.v2025-10-16.q55; 120ISTQB.ISTQB-CTAL-TA.v2025-10-15.q36; 126SAP.C-S4CFI-2408.v2025-10-15.q86; 131Oracle.1z1-076.v2025-10-15.q59; 135HP.HPE7-A08.v2025-10-15.q85; 135Docker.DCA.v2025-10-15.q113; 107DAMA.DMF-1220.v2025-10-15.q193; 129Cisco.CCST-Networking.v2025-10-14.q23; 148Lpi.303-300.v2025-10-14.q42

Question 56

Question 57

Question 58

Question 59

Download PDF File