Free Oracle 1Z1-947 Exam Dumps Questions & Answers

Which of these is a valid Replicat parameter in Oracle GoldenGate?

• A.  PASSTHRU
• B.  RmtHost
• C.  DynamicPortList
• D.  SourceDefs

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 barrier transactions in a Coordinated Replicat.
• C.  It is caused by THREAD and THREADRANGE being used with wildcard MAP statements.
• D.  It is caused by the thread with the highest thread ID applying barrier transactions.

What is the key purpose of GoldenGate trail files?

• A.  They are database auditing logs in which GoldenGate registers changes.
• B.  They are a persistent storage area for captured transactions.
• C.  They are checkpoint files for the GoldenGate processes.
• D.  They are configuration files for the GoldenGate processes.

What is the purpose of the GoldenGate Initial Load?

• A.  To create the target database objects
• B.  To carry out Performance Load Testing
• C.  To stream change data to a target database
• D.  To synchronize data in the source and target databases

You must view more than just the operation type and hex value of the data in a trail. Which setting in Logdump allows you to view the token data, LOGCSN, and TRANID in the trail?

• A.  ghdr on
• B.  detail data
• C.  ggstoken detail
• D.  fileheader on