New Questions 3

Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?

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

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

C. The Extract will abend unless LOBMEMORY is increased.

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

New Questions 4

For which database, other than SQL Server, does an Extract use a method of Secondary Truncation Point management?

A. Teradata

B. Informix

C. Sybase

D. DB2

New Questions 5

Which could be used to map a value stored in a user token to a target column?

A. @GETENV

B. GGHEADER

C. GGENVIRONMENT

D. u00a9TOKEN

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.

New Questions 7

You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?

A. Oracle Goldengate for Big Data

B. Oracle Goldengate Application Adapters

C. Oracle Goldengate Veridata

D. Oracle Data Integrator Adapters

New Questions 8

Your Replicat performance seems slow. Which Replicat parameter can be used to improve performance?

A. DEFERAPPLYINTERVAL

B. BATCHSQL

C. ASSUMETARGETDEFS

D. SPECIALRUN

New Questions 9

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

New Questions 10

Which option is an invalid GLOBALS parameter?

A. DISCARDFILE

B. GGSCHEMA

C. MGRSERVNAME

D. CHECKPOINTTABLE

New Questions 11

Which three are valid Extract or Replicat statements using the @RANGE function for an Acct table with a Primary Key on the AccountID column? (Select three.)

A. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));

B. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));

C. TABLE fin.Sales, FILTER (@RANGE (1, 2));

D. FILTER (@RANGE (2, 2, AccountID));

E. FILTER (@RANGE 2, 2, ID);

New Questions 12

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