1Z1-947 by Oracle Actual Free Exam Q&As

Question 1

With BATCHSQL enabled, what causes a Replicat to use normal mode operation?

A. When BATCHSQL and GROUPTRANSOPS coexist B. When server memory < 8 GB C. Statements with rows between 8k and 24k in length D. Statements that cause errors

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 2

What is the adminclient in GoldenGate MA?

A. A CLI tool that uses REST APIs to manage deployments B. A GUI for performance metrics visualization C. A browser-based management tool D. A background replication daemon

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 3

The IF function is used to test one or more conditions and return a value. The Replicat parameter file has the following entry:

A. Pacific B. Central C. Mountain D. East

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 4

Which of the following is a typical Oracle GoldenGate Manager parameter?

A. ExtTrail B. RmtHost C. DiscardFile D. Port

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 5

SQLEXEC can communicate only via SQL query.

A. TRUE B. FALSE

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 6

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

A. Before and after images of updates will be ignored. B. Inserts and deletes will be captured. C. Before and after images of updates will be captured. D. Inserts, updates, and deletes will be captured.

Discussion 0

Correct Answer: A Vote an answer

Question 7

You want to increase parallelism for greater integrated Replicat throughput while preserving the original transaction atomicity. How can you achieve this?

A. You can configure integrated Replicat with two parallel child servers. B. You can configure integrated Replicat with two parallel apply servers. C. You can configure integrated Replicat with SPECIALRUN parameter. D. You can configure integrated Replicat ASSUMETARGETDEFS and SPECIALRUN parameters.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 8

If multiple GoldenGate processes are accessing a set of trail files, which process should include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up?

A. Manager B. Replicat C. Extract D. Extract and Replicat

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 9

Which of the following is not an initial load method in Oracle GoldenGate?

A. File to Replicat B. File to database utility C. Direct load D. SQL*Net Load

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Oracle GoldenGate 19c Implementation Professional - 1Z1-947 Exam Practice Test