Oracle Exam 1Z0-066 Topic 3 Question 40 Discussion

Actual exam question for Oracle's 1Z0-066 exam

Question #: 40
Topic #: 3

Which two are prerequisites for configuring Transaction Guard in a Data Guard environment? (Choose two.)

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

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

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

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

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

Show Suggested Answer

Suggested Answer: A, B

To use Transaction Guard with an application, you must do the following:

* Grant permission on the DBMS_APP_CONT package to the database users who will call GET_LTXID_OUTCOME:

GRANT EXECUTE ON DBMS_APP_CONT TO <user-name>;

* Use an application service for all database work. Create the service using the srvctl command if you are using Oracle RAC, or using the DBMS_SERVICE.CREATE_SERVICE PL/SQL subprogram if you are not using Oracle RAC.

Configure the services for commit outcome and retention. For example:

COMMIT_OUTCOME = TRUE

RETENTION_TIMEOUT = <retention-value>

COMMIT_OUTCOME determines whether transaction commit outcome is accessible after the commit has executed.

References:

https://docs.oracle.com/database/121/ADFNS/adfns_trans_idemp_guard.htm#ADFNS338

by Cyril at May 09, 2022, 08:07 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-066 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!