Oracle Global Human Resources Cloud Implementation Specialist — Question 40

Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger?

Answer options

• A. Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater
• B. any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater
• C. Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater
• D. Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater

Correct answer: C

Explanation

The correct answer is C because Oracle Database 11.2.0.4 or greater, along with Integrated Extract and GoldenGate 12.1 or higher, allows for DDL replication without the need for a DDL trigger. The other options either use versions that are too low or do not meet the required specifications for avoiding a DDL trigger.