New Questions 2

You need to locate the position of the oldest unprocessed transaction by using the command INFO EXTRACT

<extractgroup> SHOWCH. How should you proceed?

A. Use the Read Startup Checkpoint.

B. Use the Read Recovery Checkpoint.

C. Use the Write Startup Checkpoint.

D. Use the Read Current Checkpoint.

View Answer

New Questions 3

Which option is an invalid GLOBALS parameter?

A. DISCARDFILE

B. GGSCHEMA

C. MGRSERVNAME

D. CHECKPOINTTABLE

View Answer

New Questions 4

How does Replicate know the structure of the source tables when the target has a different layout?

A. GoldenGate trail file contains the metadata of incoming data

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

C. Parameter file contains table layouts

D. Discard file contains table layouts

E. Source Definitions file contains table layouts

View Answer

New Questions 5

Ideally which process should be configured purge old trial files?

A. Manager

B. Extract

C. Replicat

D. Pump

View Answer

New Questions 6

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);

View Answer

New Questions 7

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

A. Manager

B. Replicat

C. Extract

D. Extract and Replicat

View Answer

New Questions 8

You have configured and added the Extract and Replicat tasks by using the Direct Load method. What do you need to do to get the processes up and running?

A. Start the Extract task.

B. Start the Extract task, wait for it to stop, and then start the Replicat task.

C. Start the Extract task and then start the Replicat task.

D. Start the Replicat task.

View Answer

New Questions 9

You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-tou2013database utility. How should you configure GoldenGate in order to accomplish this?

A. Configure Replicat with theFORMATASCII SQLLOADER OPTION.

B. Configure Extract with theFORMATSQL SQLLOADER OPTION.

C. Configure Extract with theFORMATASCII SQLLOADER OPTION.

D. Configure Replicat with theFORMATXML OPTION.

View Answer

New Questions 10

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

View Answer

New Questions 11

How can you tell if GoldenGate has been configured for batch processing?

A. TheSPECIALRUNparameter is in the Replicat parameter file.

B. Replicat is started with theINITIALLOADtask.

C. There is a dedicated GoldenGate process calledSPECIALRUN.

D. TheSPECIALRUNparameter is in theGLOBALSparameter file.

View Answer