GoldenGate 12c Implementation Free Sample Questions

Create a GLOBALS file for each installation and use the MGRSERVNAME parameter, with a unique name.

Include the parameter SERVICENAME in each Manager, with a unique name.

Accept the default service name and manually edit within the Services applet.

Multiple Manager services are not allowed on the same Windows server.

Oracle Goldengate for Big Data

Oracle Goldengate Application Adapters

Oracle Goldengate Veridata

Oracle Data Integrator Adapters

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.

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.

Implement trail file encryption.

Ensure that passwords are encrypted.

Ensure that network communications are encrypted.

Ensure that table-level Transparent Data Encryption is implemented.

The Replicat with the FORMAT RELEASE parameter.

The Extract with the FORMAT RELEASE parameter.

The Extract to write directly to the remote trail.

The collector with the FORMAT RELEASE parameter.

GoldenGate User Exits are not supported for DDL.

Source and target objects can be different.

Target objects can be different from source when using SOURCEDEFS in Replicat.

It can use WILDCARDRESOLVE IMMEDIATE.

TARGETDB TargetDSN USERID samplelD PASSWORD samplepword

SOURCEDB SourceDSN

SOURCEDB sampleDB USERID samplelD PASSWORD samplepword

TARGETDB samplelD samplepword

ENABLE_GOLDENGATE_REPLICATION=true

ENABLE_STREAMS_REPLICATION=true

Configure the STREAMS_POOL_SIZE database parameter

ENABLE_DATABASE_REPLICATION=true

stop* noinput

stop immediate *

stop * !

stop force*