Oracle Global Human Resources Cloud Implementation Specialist — Question 29

Your Extract process, which is using an Oracle database, has stopped with uncommitted transactions. How should you guarantee an efficient recovery after
Extract has stopped?

Answer options

• A. Use the FORCETRANS and PURGEORPHANEDTRANSACTIONS parameters to control the bounded recovery feature of the general Extract checkpointing facility.
• B. Use the WARNLONGTRANS parameter to control the bounded recovery feature of the general Extract checkpointing facility.
• C. Use the BR parameter to control the bounded recovery feature of the general Extract checkpointing facility.
• D. Use the PURGEORPHANEDTRANSACTIONS parameter to control the bounded recovery feature of the general Extract checkpointing facility.

Correct answer: C

Explanation

The correct answer is C, as the BR parameter specifically controls the bounded recovery feature, which is crucial for managing uncommitted transactions effectively. Options A and D, while relevant, do not directly address the bounded recovery aspect as efficiently as the BR parameter does. Option B does not pertain to recovery management in this context.