GoldenGate Interview Question-Set-1
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)-Why you need supplemental logging enabled for Golden Gate? If supplemental logging is not enabled will my transaction get failed? 2)-If you don’t have PK/UK in your tables and those tables are the part of GG then how it will be replicated? or replication is not possible at all? 3)-What is the difference between CLASSIC and INTEGRATED EXTRACT? And how to identify if EXTRACT is classic or INTEGRATED? 4)-Why PUMP is mandatory or recommended to configure? 5)-Can we do filtration on the Extract side? 6)-What, if a transaction 2 is committed first and transaction1 is still uncommitted while it has started at 10:00, am and T2 started at 10:30. What will happen? 7)-What is the parameter to encrypt the data while transferring from local trail files to remote trails? 8)-Does INITIAL load require Archive or Redo? 9)-If Initial load extract fails In between, from which point it will start? 10)-If DB is in read-only mode, will checkpoint and archive process be available or disabled?
With Best Wishes!!!!
Oracle Database Consultant
Certified in-: | 6X OCI|OCS (ADB)|OCS (GG)|OCE (RAC)|OCP (11g,10g,9i) |OCA (9i) |