Online Access Free 1z1-481 Exam Questions

You are configuring a multi-master DDL replication environment. To prevent looping of DDL statement like CREATE TABLE (....), the best solution is______.

• A.This feature is not supported in GoldenGate 10.
• B.Use the add FILTERTABLE command at the GGSCI prompt
• C.Use DDL exclude OPTYPE (create table. . . ) in one Extract to prevent looping
• D.Include the tranlogoptions (exclude user) parameter in each Extract parameter file

Which Manager Parameter sets will report current lag every hour and write a critical message for any Extract/Replicate with a lag over 60 minutes?

• A.LAGBEPOBTHOURS 1, LAGINFO 1 and LAGCRITICAL 60
• B.LAGREPOBT 1, I.AGCRITICALHOURS 1
• C.LAGREPOBTHOURS 1, LAGINFOMINUTES 30, LAGCR JTTCAI-M I
• D.LAGREPORTMINUTES 60, LAGINFOHOURS 1

By default, which option is evaluated first, SQLEXEC or filter statement?

• A.SQLEXEC
• B.It depends on their position in the parameter file; the first encountered is executed first.
• C.There is no default; it is set with the after filter I before filter.
• D.FILTER

What Oracle GoldenGate feature provides recoverability without loss of transactions?

• A.Two-phase commits
• B.Sub-second latency
• C.Transactional integrity
• D.Checkpointing

If multiple GoldenGate processes are accessing a set of trial files which of the processes should include the PURGEOLDEXTRACTS parameter to trigger trail file clean up?

• A.Extract
• B.Both Extract and Replicat
• C.Replicat
• D.Manager