Oracle GoldenGate 12c: Fundamentals for Oracle Ed 2 Quiz Questions and Answers

Which command provides statistics about GoldenGate processes and memory resource utilization?

Answer :
  • SEND…CACHEMGR

You want to monitor replication not only to check that the processes are running, but to specifically verify that the data continuously replicates.How should you accomplish this?

Answer :
  • Monitor the GoldenGate lag and last checkpoint time statistics

You must replicate to JMS Queues, Which product in the Oracle GoldenGate portfolio should be used?

Answer :
  • Oracle Goldengate Application Adapters

Your Replicat performance seems slow.Which Replicat parameter can be used to improve performance?

Answer :
  • BATCHSQL

When is a Pump not required to connect to a source database?

Answer :
  • when look-ups are needed against the source database

What is the function of the GoldenGate JAgent?

Answer :
  • It enables communication between GoldenGate and Monitor, and Enterprise Manager Agent

What software is required prior to running Oracle GoldenGate in a Windows Server environment?

Answer :
  • Microsoft Visual C++ 2010 SP1 Redistributable Package

How should you determine whether all of the processes are using the newest version so that you can delete older

Answer :
  • View the report file of each Extract immediately after renewing the master key to confirm the last SCN that was mined with the old key. Then, monitor the Replicat report files to verify that this SCN was applied by all Replicat groups

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

Answer :
  • It is caused by barrier transactions in a Coordinated Replicat.

You must synchronize the starting point for Replicat with the restore point of the target database. How should

Answer :
  • Use the command option AFTERCSN.