Oracle Database 12c: RAC and Grid Infrastructure Administration — Question 50

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

Answer options

• A. Grant execute permission on the DBMS_APP_CONT package to relevant database schema owners.
• B. Create a database service with COMMIT_OUTCOME set to TRUE, and ensure clients use that service to connect to the database instance.
• C. Ensure that connection descriptors for database clients use the failover clause with the COMMIT_OUTCOME parameter set to TRUE.
• 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

Correct answer: A, B

Explanation

The correct answers, A and B, are essential for configuring Transaction Guard, as granting execute permission on the DBMS_APP_CONT package and creating a service with COMMIT_OUTCOME set to TRUE are foundational requirements. The other options, while relevant to Data Guard configurations, do not directly pertain to the prerequisites for Transaction Guard specifically.