Question 1

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

Question 2

You must locate the next good record header in a Logdump file. How should you do this?

Options :

A : Logdump > SCANFORENDTRANS

B : Logdump > SCANFORHEADER

C : Logdump > GHDR ON

D : Logdump > SCANFORGHDR

Answer: B

Question 3

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

Options :

A : FALSE

B : TRUE

Answer: A

Question 4

Oracle GoldenGate writes OS-level errors to:

Options :

A : Discard file

B : Process report

C : Event log

D : System log

Answer: D

Question 5

Which option is an invalid GLOBALS parameter?

Options :

A : GGSCHEMA

B : CHECKPOINTTABLE

C : DISCARDFILE

D : MGRSERVNAME

Answer: C