Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

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.

COBGEN file in the GoldenGate installation location

C.

GGSKEY file in the GoldenGate data location

D.

GGSKEY file in the GoldenGate installation location

E.

ENCKEYS file in the GoldenGate installation location

Which two are valid macros?

A.

Option A

B.

Option B

C.

Option C

D.

Option D

You need to configure the source database, target database, and Oracle GoldenGate for conflict detection and resolution (CDR). You want the full before image of each record, but your database does not provide a before image in the log record and must be configured to do so with supplemental logging.

How should you proceed?

A.

Include theOVERWRITEcommand.

B.

Include theUSEDELTAcommand.

C.

Include theADD TRANDATAcommand.

D.

Include theUPDATAROWEXISTScommand.

Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate?

A.

ENABLE_GOLDENGATE_REPLICATION=true

B.

ENABLE_STREAMS_REPLICATION=true

C.

Configure theSTREAMS_POOL_SIZEdatabase parameter

D.

ENABLE_DATABASE_REPLICATION=true

You must configure GoldenGate parameter files for conflict resolution and want to be sure that the before values are compared with current values in the target database to detect update and delete conflicts.

How should you accomplish this?

A.

Use theCOMPCOLSwith theGETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHERE clause.

B.

Use theCOMPARECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

C.

Use theGETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

D.

Use theGETBEFORECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

Which statement is valid for DDL replication?

A.

GoldenGate User Exits are not supported for DDL.

B.

Source and target objects can be different.

C.

Target objects can be different from source when usingSOURCEDEFSin Replicat.

D.

It can useWILDCARDRESOLVE IMMEDIATE.

Which three describe a valid OGG Event Action?

A.

Stop the process

B.

Write a checkpoint before and/or after writing the record to the trail.

C.

Run a shell command

D.

Purge old trail files

You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you

differentiate the different Manager services?

A.

Create aGLOBALSfile for each installation and use theMGRSERVNAMEparameter, with a unique name.

B.

Include the parameterSERVICENAMEin each Manager, with a unique name.

C.

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

D.

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

What software is required prior to running Oracle GoldenGate in a Windows Server environment?

A.

Oracle Gateway software configured for that particular database platform

B.

JDBC drivers into the GoldenGate home directory

C.

Microsoft Visual C++ 2010 SP1 Redistributable Package

D.

Nothing, configure GoldenGate Jagent for that particular database platform.

Which is an incorrect syntax for connecting to a source or target database by an Extract or Replicat?

A.

TARGETDB TargetDSN USERID sampleID PASSWORD samplepword

B.

SOURCEDB SourceDSN

C.

SOURCEDB sampleDB USERID sampleID PASSWORD samplepword

D.

TARGETDB sampleID samplepword