Free Oracle 1Z0-947 Exam Questions

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?

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

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?

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

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

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?

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

A Distribution Path sends the transaction of data from Extract to Replicat. How can you create a Distribution Path?

A : From Cloud Shell with REST APIs

B : From the Service Manager home page

C : In GGSCI with GoldenGate commands

D : At OS prompt with run preceding the GoldenGate commands

Answer: B