Question 1

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 2

In Oracle RDBMS sharding architecture, shardgroups checkpoint their data on a shared disk to ensure data integrity.

Options :

A : FALSE

B : TRUE

Answer: A

Question 3

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 4

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