Free Oracle 1Z0-947 Exam Questions

Become Oracle Certified with updated 1Z0-947 exam questions and correct answers

Page: 1 / 29

Total 144 Questions | Updated On: Sep 22, 2026

Add To Cart

Question 1

When should the KeyCols parameter be used?

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

User exits can be used for tables processed by a data pump Extract in passthru mode.

A : FALSE

B : TRUE

Answer: A

Question 3

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

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 4

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