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: Apr 03, 2026

Add To Cart

Question 1

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

A : FALSE

B : TRUE

Answer: A

Question 2

Which valid Extract or Replicat statements using the @RANGE function for an Acct table with a Primary Key on the AccountID column?

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 3

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

Answer: B

Question 5

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