Oracle WebLogic Server 12c: Administration I — Question 27

You need to configure WebLogic Server to satisfy the needs of your new application that will update more than one data set on several databases in the same transaction.
All updates will be committed or rolled back at the end of the transaction.
Which setting should be considered?

Answer options

• A. Enable Use XA Data Source Interface in the transaction properties of each data source.
• B. WebLogic Server supports distributed transactions by default, so no specific settings are required.
• C. Split the transaction into multiple local transactions.
• D. Configure your data sources with the available XA-compliant driver for your DBMS.
• E. Enable Two-Phase Commit in each data source.

Correct answer: E

Explanation

The correct answer is E because enabling Two-Phase Commit ensures that all data sources involved in the transaction can coordinate the commit or rollback process, which is essential for maintaining data integrity across multiple databases. Options A and D are related to XA transactions but do not directly address the requirement for Two-Phase Commit. Option B incorrectly states that no settings are needed, while option C suggests an inefficient approach by splitting the transaction.