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?
With Best Wishes!!!!
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