If your system has a firewall controlling port access which parameter can be used to control ports used for GoldenGate processes? A. CHILDPORTS B. ALLOWEDPORTS C. DYNAMICPORTLIST D. GETPORTINFO

Where are GoldenGate macros defined? A. Macros can be defined in the parameter file or included in a macro file B. Macros are defined in the GLOBALS parameter file C. Macros are placed in a file and referenced using an…

Which parameter tells Extract the tables for which to capture changes? A. Table B. LOGTABLE C. MAP C D. LOG

Which three can GoldenGate encrypt? A. Extract to Server messages B. Trails C. Passwords D. Redo logs

What three are valid responsibilities of the OGG Manager? A. Cleaning up GoldenGate trails. B. Starting dynamic processes, such as Server Collectors, extracts, replicates. C. Error and lag reporting. D. Communicating with other GoldenGate Manager processes

You are configuring replication between two Oracle tables with the same number of columns, column table names, and data types, but in different orders. For replication purpose can you treat these as identical tables? A. No B. Yes, if the…

You have configured and added the extract and Replicate tasks using the direct load method what do you need to do to get the processes up and running? A. Start the Extract task. B. Start the Extract task and then…

Which three types of information are stored in the GoldenGate trial header? A. Before or after image indicator B. Data type (e.g. integer, alphanumeric) C. Relative byte address of the commit record D. Time of the transaction

When would you use the PASSTHRU parameter? A. When using a data pump to distribute all of the trail data "as is" to a remote system. B. When Extract is processing database transaction logs where you have a remote database…

What Oracle GoldenGate feature provides recoverability without loss of transactions? A. Checkpointing B. Sub-second latency C. Two-phase commits D. Transactional integrity