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