Online Access Free 1z0-481 Exam Questions

When implementing GoldenGate on a 11gR2 Oracle database and after running the GoldenGate Database profiling script, you discover that certain objects are compressed, what should you do?

• A.Configure OGG with Integrated Capture
• B.Configure OGG with Classic Capture
• C.Contact Oracle support
• D.Continue the implementation of OGG and exclude those objects from replication

Neither your source, nor your target table has a primary key, and you have not designated KEYCOLS. How will the Replicat proceed to identify matching target rows to update or delete?

• A.The combination of all fields up to the first thirty-two will be treated as a compound primary key
• B.The first unique key alpha-numerically, excluding virtual columns and nullable columns, will be treated as the primary key.
• C.This configuration is not supported by GoldenGate; Replicat will abend on updates or deletes.
• D.The first column, excluding virtual columns and nullable columns, will be treated as the pr key.

Which statements are true for a two-node, active-active OGG replication configuration?
-Both databases may be live and processing transactions.
-The two databases must be homogeneous. -Low latency reduces the risk of conflicts.

• A.2 and 3
• B.1 and 3
• C.I, 2, and 3
• D.1 and 2

You are responsible for replication between your central office and twelve regional nodes. What is the best product for you to use to actively monitor thirteen GoldenGate TDM instances and configure email alerts based on process status?

• A.Oracle GoldenGate Director
• B.Oracle GoldenGate Monitor
• C.Oracle GoldenGate Transactional Data Management
• D.Oracle GoldenGate veridata

What is the name and the location of the file that lists the key values used by extract for encryptions and Server Collector for decryption?

• A.KEYGEN file in the GoldenGate data location
• B.ENCKEYS file in the GoldenGate installation location
• C.COBGEN file in the GoldenGate installation location
• D.GGSKEY file in the GoldenGate installation location
• E.GGSKEY file in the GoldenGate data location