Oracle Global Human Resources Cloud Implementation Specialist — Question 21

You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?

Answer options

• A. It is caused by THREAD and THREADRANGE being used with wildcard MAP statements.
• B. It is caused by the thread with the highest thread ID applying barrier transactions.
• C. It is caused by the use of the MAXTRANSOPS parameter.
• D. It is caused by barrier transactions in a Coordinated Replicat.

Correct answer: D

Explanation

The correct answer is D because barrier transactions are designed to ensure that certain transactions are completed before others can proceed, leading to threads waiting. Options A, B, and C do not directly relate to the issue of threads waiting on a specific transaction, as they pertain to different mechanisms or configurations.