Online Access Free 1Z1-947 Exam Questions

Oracle GoldenGate is a middleware software and can be used for business intelligence to support a heterogeneous database environment.

• A.FALSE
• B.TRUE

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?

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

You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?

• A.It is caused by the use of the MAXTRANSOPS parameter.
• B.It is caused by THREAD and THREADRANGE being used with wildcard MAP statements.
• C.It is caused by the thread with the highest thread ID applying barrier transactions.
• D.It is caused by barrier transactions in a Coordinated Replicat.

Which of these can you not do from the main page of the MA Administration Server web page?

• A.See the lag time of currently configured Extracts and Replicats.
• B.Create an Extract or Replicat.
• C.Fix the situation of what caused the Extract or Replicat to be down from the Critical Event box.
• D.Restart configured Extracts and Replicats.

User exits can be used for tables processed by a data pump Extract in passthru mode.

• A.FALSE
• B.TRUE