What should you use to look up the PRODUCT_DESCRIPTION for each transaction?

Correct Answer for the following Question is given below You have a source table with a PRODUCT_ID column and a target table with PRODUCT_DESCRIPTION column. On the target database, there is a lookup table containing product codes and corresponding descriptions. What should you use to look up the PRODUCT_DESCRIPTION for each transaction? Question: What should … Read more

Which Logdump command is used to check how many change records are in the trail file?

Correct Answer for the following Question is given below Which Logdump command is used to check how many change records are in the trail file?Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GLOGD/wu_logdump.htm#GLOGD121 Question: Which Logdump command is used to check how many change records are in the trail file? Options: STATS REPORT REPORTCOUNT COUNT Correct Answer The Correct Answer for this … Read more

What is this issue related to?

Correct Answer for the following Question is given below You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_changesync.htm#GWUAD953 Question: What is this issue related to? Options: It is caused by THREAD andTHREADRANGE being used with wildcard MAP statements. It is … Read more

Which process should you configure the warning for long-running transactions?

Correct Answer for the following Question is given below In which process should you configure the warning for long-running transactions?Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/gg_parameters015.htm#GWURF410 Question: Which process should you configure the warning for long-running transactions? Options: Jagent Extract Replicat Manager Correct Answer The Correct Answer for this Question is Extract Explanation The Question – Which process should you … Read more

How should you accomplish this?

Correct Answer for the following Question is given below You want to monitor replication not only to check that the processes are running, but to specifically verify that the data continuously replicates. How should you accomplish this?Reference: http://www.oracle.com/technetwork/articles/havawala-goldengate-091741.html Question: How should you accomplish this? Options: Implement GoldenGate Monitor. Have the customer continuously update the application … Read more

Which Replicat parameter should you use?

Correct Answer for the following Question is given below You need to look up table definitions in a file. Which Replicat parameter should you use? Question: Which Replicat parameter should you use? Options: ASSUMETARGETDEFS COLMATCH SOURCEDEFS MAP Correct Answer The Correct Answer for this Question is SOURCEDEFS Explanation The Question – Which Replicat parameter should … Read more

Which method in GoldenGate should you use to undo DML changes previously made to a target database?

Correct Answer for the following Question is given below Which method in GoldenGate should you use to undo DML changes previously made to a target database?Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_backout.htm#GWUAD721 Question: Which method in GoldenGate should you use to undo DML changes previously made to a target database? Options: Run Extract and Replicat from the command line. Use … Read more

Which option is supported by GoldenGate DDL replication?

Correct Answer for the following Question is given below Which option is supported by GoldenGate DDL replication?Reference: https://docs.oracle.com/goldengate/c1230/gg-winux/GGHDB/using-ddl-replication.htm#GGHDB-GUID-B7A3B3AF-B5DE-47B3-8B0FC6D5FCB5388C Question: Which option is supported by GoldenGate DDL replication? Options: CREATE ROLE ALTER SYSTEM ALTER DATABASE ALTER TABLE SYS Correct Answer The Correct Answer for this Question is ALTER TABLE SYS Explanation The Question – Which option … Read more

How should you accomplish this?

Correct Answer for the following Question is given below You want to reduce an Integrated Extract’s startup time by using an existing data dictionary. How should you accomplish this? Question: How should you accomplish this? Options: Set the shared memory realm of an Integrated Extract with other Integrated Extracts. Use the SHARE option of the … Read more

How should you configure GoldenGate in order to accomplish this?

Correct Answer for the following Question is given below You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-to-database utility. How should you configure GoldenGate in order to accomplish this?Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_initsync.htm#GWUAD546 Question: How should you configure GoldenGate in order to accomplish this? Options: … Read more