Oracle Global Human Resources Cloud Implementation Specialist — Question 39

Which option is supported by GoldenGate DDL replication?

Answer options

• A. CREATE ROLE
• B. ALTER SYSTEM
• C. ALTER DATABASE
• D. ALTER TABLE SYS

Correct answer: D

Explanation

The correct answer is D, as GoldenGate DDL replication supports the operation of altering tables, including those in the SYS schema. Options A, B, and C are not supported by GoldenGate DDL replication, as they pertain to user roles, system settings, and database configurations, which are outside the scope of DDL replication.