Saturday 4 November 2017

oracle GoldenGate interview questions

1. What is different b/w 11g and 12c GG?
-11g supports only classic extract.
-In 12c integrated extract is introduced.
-12c support internal parallelism for replicat to increase apply performance.
-automatic CDR.
2. What is diff b/w integrated method and classic method?
3. What is the advantage if we use pump process?
- by using pump we can avoid impact of network issues, if trail file currupted in target host we can resend it by using pump since we maintain one copy of trail file in source host.
- Recovery will be easy if any trail file currupted in target.
4. What are the trail files?
-trail files are binary files that are maitained by goldengate to store replicate data.
5. What are the different checkpoints in goldengate.
-capture check poitn and replicate check point.
6. What is difference b/w lag at chkpt and time since chkpt.
7. What is logdump utility?
-logdump is goldengate utility used to handle trailfiles.
8. What is RBA in trailfile?
9. How to find number of transactions in a trailfile?
- using COUNT command in logdump utility.
10. From which database version supports integrated extract/replicate.
- RDBMS 11.2.0.3
11. Which process supports from database end for integrated extract.
-logmining server process
12. Which process supports from database end for integrated replicat.
-inbound server process
13. Checkpoint table is required for integrated replicat?
-No
14. What is the diff b/w coordinated and integrated replicat.
15. what is tranlog in goldengate level.
16. what is PASSTHROU parameter
17. what is ASSUMETARGETDEFS parameter
18. what is credential store
19. what is discard file. what data it will stores.
20. what si BATCHSQL mode.
21. difference between Lag at checkpoit and Time since checkpoint.
22. what is CDR.
23. what all manager process can do.

No comments:

Post a Comment