Oracle Global Human Resources Cloud Implementation Specialist — Question 48

You need to configure the source database, target database, and Oracle GoldenGate for conflict detection and resolution (CDR). You want the full before image of each record, but your database does not provide a before image in the log record and must be configured to do so with supplemental logging.
How should you proceed?

Answer options

• A. Include the OVERWRITE command.
• B. Include the USEDELTA command.
• C. Include the ADD TRANDATA command.
• D. Include the UPDATAROWEXISTS command.

Correct answer: C

Explanation

The correct answer is C because the ADD TRANDATA command is used to enable supplemental logging for a table, allowing the capture of the full before image. The other options do not apply to enabling supplemental logging or do not address the requirement of capturing before images effectively.