New Questions 3

Which statement regarding the GoldenGate Data Pump is incorrect?

A. Data Pump is a separate process.

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

C. Data Pump has distance limitations.

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

View Answer

New Questions 4

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.

View Answer

New Questions 5

What is the default threshold for message compression in OGG?

A. 1000

B. 100

C. O

D. By default, messages are not compressed.

View Answer

New Questions 6

Which method in GoldenGate should you use to undo DML changes previously made to a target database?

A. Run Extract and Replicat from the command line.

B. Use Extract and Replicat with the GoldenGate Logdump utility.

C. Run the Reverse Utility on the target database transaction logs.

D. Use Extract and Replicat with the GoldenGate Reverse utility.

View Answer

New Questions 7

You must implement GoldenGate in a master-to-master configuration. What output from the profiling scripts should you look for to ensure that your implementation is correct?

A. Tables set with nologging

B. Tables with Large Object (LOB) data types

C. Tables that have conflicts

D. Triggers and sequences

View Answer

New Questions 8

Your Extract process, which is using an Oracle database, has stopped with uncommitted transactions. How should you guarantee an efficient recovery after Extract has stopped?

A. Use theFORCETRANSandPURGEORPHANEDTRANSACTIONSparameters to control the bounded recovery feature of the general Extract checkpointing facility.

B. Use theWARNLONGTRANSparameter to control the bounded recovery feature of the general Extractcheckpointing facility.

C. Use theBRparameter to control the bounded recovery feature of the general Extract checkpointing facility.

D. Use thePURGEORPHANEDTRANSACTIONSparameter to control the bounded recovery feature of the general Extract checkpointing facility.

View Answer

New Questions 9

Which statement correctly explains when you would use ASSUMETARGETDEFS?

A. The target tables are already created.

B. Only the fields in the target tables are mapped.

C. The source and target tables have identical data structure.

D. You have specified wildcards in either the TABLE or MAP parameters

View Answer

New Questions 10

If multiple GoldenGate processes are accessing a set of trial files which of the processes should include the PURGEOLDEXTRACTS parameter to trigger trail file clean up?

A. Manager

B. Extract

C. Replicat

D. Both Extract and Replicat

View Answer

New Questions 11

You are implementing GoldenGate monitoring via the Enterprise Manager Plug-In. When you start JAgent, it fails with u201cajavA.lang.Exception: One or more Java Agent properties in Config.properties are not defined properlyu201d.

What is the first thing to check?

A. if The Enterprise Manager Agent is running

B. if the JAgent has been enabled in the GoldenGate Manager

C. if the agent type is set to OEM in JAgent properties

D. if the Oracle Wallet has been created for the JAgent

View Answer

New Questions 12

Which GLOBALS parameter is required to initially enable monitoring?

A. JAGENTMONITORING

B. ENABLEMONITORING

C. ENABLEOEMMONITORING

D. CHECKMONITORING

View Answer