Question 1

When should the KeyCols parameter be used?

Options :

A : In addition to the unique index

B : To define a substitute primary key

C : In addition to the primary key

Answer: B

Question 2

Oracle GoldenGate Software Command Interface (GGSCI) is the Oracle GoldenGate command-line utility. You use GGSCI commands to configure, control, and monitor Oracle GoldenGate. GGSCI commands can be collected in a text script called an Obey (.oby) file. How can it be run in Obey scripts and also used in Microservices architecture?

Options :

A : Run it on the OS logged in as user oggadmin.

B : Log into source or target database as user oggadmin and run script at SQL prompt.

C : Launch GGSCI and run from the GGSCI prompt.

D : Run scripts from adminclient.

Answer: D

Question 3

What command options specify Extract and Replicat batch mode for initial load?

Options :

A : ADD REPLICAT WITH SPECIALRUN

B : ADD EXTRACT WITH SOURCEISTABLE

C : ADD REPLICAT WITH PASSTHRU

D : ADD EXTRACT WITH TRANLOGOPTIONS

Answer: A,B

Question 4

The Healthcheck (ICRHC) script is shipped with Oracle DB and found in

Options :

A : FALSE

B : TRUE

Answer: A

Question 5

Which valid Extract or Replicat statements using the @RANGE function for an Acct table with a Primary Key on the AccountID column?

Options :

A : FILTER (@RANGE (2, 2, AccountID));

B : FILTER (@RANGE 2, 2, ID);

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

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

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

Answer: E