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

Question 1

What is the purpose of the GoldenGate Initial Load?

A. To synchronize data in the source and target databases B. To carry out Performance Load Testing C. To create the target database objects D. To stream change data to a target database

Discussion 0

Correct Answer: A Vote an answer

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

Question 2

Which of the following statements is true?

A. The Oracle GoldenGate checkpoint supports Oracle GoldenGate recovery. B. The CKPT background process records the Oracle GoldenGate checkpoint. C. There is likely to be only one Oracle GoldenGate checkpoint file. D. Oracle GoldenGate checkpoints are stored in an Oracle control file.

Discussion 0

Correct Answer: A Vote an answer

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

Question 3

Which parameter for GoldenGate 19c enables DDL replication for a Replicat?

A. Enabled by default B. GETDDL C. USEDDL D. TARGETDDL

Discussion 0

Correct Answer: A Vote an answer

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

Question 4

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

A. TABLE fin.Sales, FILTER (@RANGE (1, 2)); B. FILTER (@RANGE 2, 2, ID); C. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID)); D. MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID)); E. FILTER (@RANGE (2, 2, AccountID));

Discussion 0

Correct Answer: D Vote an answer

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

Question 5

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 include 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 insert if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000. D. Data processing will exclude rows for delete if (PRODUCT_PRICE * PRODUCT_AMOUNT) is not greater than 10000.

Discussion 0

Correct Answer: B Vote an answer

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

Question 6

Which mechanism is used by Extract to ensure that data integrity and fault tolerance are maintained in the data source and trail?

A. Commit sequence order B. Logical change records C. Checkpoints D. Manager process

Discussion 0

Correct Answer: C Vote an answer

Question 7

DDL can be used in conjunction with filter options. What would be the correct DDL parameter if you need DDL for specific objects?

A. DDL Include. <objectname> B. DDL Exclude All, Include ObjName <objectname> C. DDL Include All, Exclude ObjName <objectname> D. DDL <objectname>

Discussion 0

Correct Answer: B Vote an answer

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

Question 8

Where can Oracle GoldenGate software be downloaded officially?

A. OTN or http://edelivery.oracle.com B. Oracle Cloud Marketplace C. My Oracle Support D. Oracle Database Utilities

Discussion 0

Correct Answer: A Vote an answer

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