Question 1

What is a valid net result for an Extract configured with the parameters in this order: GETINSERTS, GETUPDATEBEFORES, IGNOREDELETES, IGNOREUPDATES?

Options :

A : Inserts, updates, and deletes will be captured.

B : Before and after images of updates will be captured.

C : Before and after images of updates will be ignored.

D : Inserts and deletes will be captured.

Answer: C

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

Which option is an invalid GLOBALS parameter?

Options :

A : GGSCHEMA

B : CHECKPOINTTABLE

C : DISCARDFILE

D : MGRSERVNAME

Answer: C

Question 4

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 5

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

Free 1Z0-947 Mock Exam – Practice Online Confidently

Buying Options: