GoldenGate Interview Question Set-4

My DBA Community,

My today’s post is very important for those who are looking for a job and preparing for an Interview. GoldenGate is a very hot technology these days. That’s why I am writing GG interview questions.

I hope these IQ will help you.

1)-What are the packages we use in GG 12c Integrated extract?

2)-If the table is not already on target how to create?

3)-Scenario: If you put the wrong table name in the replicate side and after many transactions, you came to know that table was wrong, what will happen?

4)-What is the Handlecollision?

5)-If you get ORA-0143 No data found. What will you do?

6)-What is the difference between START EXT_NAME and START EXT_NAME BEGIN NOW.

7)-By mistake I start my extract with beginning now option. Now I want to take back my extract behind, How I will do and what is the impact on the replicate side?
8)-What are the steps to add supplemental logging?

9)-If extract is not running, then how you will identify the pump and replicate which are associated with that?

10)-Can we have two extracts for one table in GG?

Thanks
With Best Wishes!!!!

Ahmad
Cloud Architect
Oracle Database Consultant

Certified in-: | 6X OCI|OCS (ADB)|OCS (GG)|OCE (RAC)|OCP (11g,10g,9i) |OCA (9i) |

YouTube Channel: https://www.youtube.com/c/OracleRide