1z0-447 Oracle GoldenGate 12c Implementation Essentials Questions and Answers

The Extract will revert to single-row fetch mode, and then resume array fetches afterwards.

The Extract will revert to single-row fetch mode for all tables.

The Extract will abend unless LOBMEMORY is increased.

The Extract will perform poorly due to paging unless LOBMEMORY is increased.

Data Pump is a separate process.

Data Pump can be used to pump trail records to multiple locations.

Data Pump has distance limitations.

Data Pump uses TCP/IP to route the trail records.

Tables set with nologging

Tables with Large Object (LOB) data types

Tables that have conflicts

Triggers and sequences

GoldenGate trail file contains the metadata of incoming data

Replicat uses an ODBC connection to connect to the source system tables

Parameter file contains table layouts

Discard file contains table layouts

Source Definitions file contains table layouts

Run Extract and Replicat from the command line.

Use Extract and Replicat with the GoldenGate Logdump utility.

Run the Reverse Utility on the target database transaction logs.

Use Extract and Replicat with the GoldenGate Reverse utility.

DISCARDFILE

GGSCHEMA

MGRSERVNAME

CHECKPOINTTABLE

Oracle Gateway software configured for that particular database platform

JDBC drivers into the GoldenGate home directory

Microsoft Visual C++ 2010 SP1 Redistributable Package

Nothing, configure GoldenGate Jagent for that particular database platform.