Exam 1z0-447 All QuestionsBrowse all questions from this exam
Question 10

Which statement is valid for DDL replication?

    Correct Answer: D

    The WILDCARDRESOLVE parameter in Oracle GoldenGate can be set to IMMEDIATE to process wildcards correctly in DDL statements. If WILDCARDRESOLVE is set to any value other than the default DYNAMIC, including IMMEDIATE, it must be configured properly to avoid process errors. Therefore, the option stating that DDL replication can use WILDCARDRESOLVE IMMEDIATE is valid.

Discussion
KelemOption: A

A is the correct answer

JESUSBBOption: A

A is the correct answer

JatindraOption: A

CORRECT ANSWER: A

antonicaOption: D

Object names must be fully qualified with their two-part or three-part names when supplied as input to any parameters that support DDL synchronization. You can use the question mark (?) and asterisk (*) wildcards to specify object names in configuration parameters that support DDL synchronization, but the wildcard specification also must be fully qualified as a two-part or three-part name. To process wildcards correctly, the WILDCARDRESOLVE parameter is set to DYNAMIC by default. If WILDCARDRESOLVE is set to anything else, the Oracle GoldenGate process that is processing DDL operations will abend and write the error to the process report. D is the answer https://docs.oracle.com/en/middleware/goldengate/core/21.3/oracle-db/configuring-ddl-support.html#GUID-B73C7C8F-D270-4679-8C62-10A557B0418C

odba2014Option: C

C is correct

DinhHuyHoangOption: C

C is correct answer

RongLeiOption: D

I think is D