Free Oracle 1Z1-947 Exam Dumps Questions & Answers


Exam Code/Number:	1Z1-947Join the discussion
Exam Name:	Oracle GoldenGate 19c Implementation Professional
Certification:	Oracle
Free Question Number:	147
Publish Date:	Oct 05, 2026
# of views:	1332
Rating 100%

Page: 1 / 30
Total 147 questions

Question 1

What is GGSCI in Oracle GoldenGate?

A.Extract checkpoint viewer
B.GUI-based replicat monitor
C.Report generation engine
D.Command interpreter for managing GG processes

Question 2

The filter clause provides the ability to include or exclude data to process. What is true with this filter clause: Filter (ON UPDATE, ON DELETE, @Compute(PRODUCT_PRICE * PRODUCT_AMOUNT) > 10000)

A.Data processing will exclude rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
B.Data processing will exclude rows for update if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
C.Data processing will include rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000
D.Data processing will include rows for insert if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000

Question 3

Which database setting for the Oracle 19c database is required to enable Oracle GoldenGate?

A.ENABLE_GOLDENGATE_REPLICATION=true
B.Configure the STREAMS_POOL_SIZE database parameter
C.ENABLE_STREAMS_REPLICATION=true
D.ENABLE_DATABASE_REPLICATION=true

Question 4

Table A has (ColA number Primary Key, ColB char(2), ColC varchar(10)) with one record with the following data: (1, 'AB', 'TestData') What will Extract capture by default for an update on ColC?

A.Before Image (1, 'TestData') + After Image (1, 'NewValue')
B.After Image (1, 'NewValue')
C.Before Image (1, 'AB', 'TestData') + After Image (1, 'AB', 'NewValue')
D.After Image (1, 'AB', 'NewValue')

Question 5

Which tools would you use to determine if all Oracle GoldenGate processes are up and running?

A.Oracle GoldenGate Monitor
B.tcpers
C.Process report
D.CMDSEC
E.GGSCI