1Z0-539 Exam Questions

What us expected behavior of CHEKPARMS parameter?

What GoldenGate facility allows for custom processing in response to a data value?

How would you specify the data source for a secondary Extract functioning as a data pump?

In order to add delete Replicat processes without specifying a checkpoint table, Gerald has edited the GLOBALS parameter file. To get the change to take effect, Gerald exits from t...

Where can you find a list of the parameters being used by a Replicat process? Oracle 1Z0-539 Exam

Which process (es) maintain a checkpoint file?

In addition to using the parameter comment to enter remarks in parameter file(s) can be used?

Which three can GoldenGate encrypt?

Which parameter tells Extract the tables for which to capture changes?

Where are GoldenGate macros defined?

If your system has a firewall controlling port access which parameter can be used to control ports used for GoldenGate processes?

Which statement best describes the record Image that an Extract process stores in the GoldenGate trail by default?

When GoldenGate is configured for Archived Only Mode (ALO), what must be considered configuring the middle-tier server for Capture?

You are configuring a multi-master DDL replication environment. To prevent looping of DDL statement like CREATE TABLE (....), the best solution is______.

You have source table with PRODUCT-ID column and target table with PRODUCT_DESCRIPTION. On the target database is a lookup table containing product codes and corresponding descript...

How many Extracts can write to the same GoldGate trail?

Which utility is responsible for generating source data definitions files?

What is the default threshold for message compression in OGG?

What is the name and the location of the file that lists the key values used by extract for encryptions and Server Collector for decryption?

By default which type of operations are captured by extract?

Which three are types of encryption supported by OGG?

Which three are required to correctly configure an OGG?

What process is the recommended method to purge old GoldenGate trials?

Which statement correctly explains when you would use ASSUMETARGETDEFS?

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

Which parameter could you use to start an Extract when Manager starts?

Which could be used to map a value stored in a user token to a target column?

Ideally which process should be configured purge old trial files?

When would you use the PASSTHRU parameter?

Which three types of information are stored in the GoldenGate trial header?

What Oracle GoldenGate feature provides recoverability without loss of transactions?

Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?

What file must be configured in order to use custom encryption keys?

Which parameters) would be used for one-time initial replicat?

What is the default format for a GoldenGate trail?

You have discovered that an OGG checkpoint table has become corrupted. What is your best strategy to recover From this?

Which statements are true of goldenGate password encryption? A password can be encrypted and pasted into a parameter file. An encrypted password can be generated using the default...

You want to configure replication of CREATE TABLE statements from oracle to Teradata, so that only new table created in your mapped source schema is Replicated. Which should be the...

Which translations are captured if you ADD EXTRACT BEGIN now 1:00 p.m., but START EXTRACT at 2:00 p.m.?

You want encrypt message sent or over TCP/IP to server usserver1, where the goldenGate manage process is running on port 7809. Your requirements include using a custom encryption k...

Which three describe a valid OGG Event Action?

By default, which option is evaluated first, SQLEXEC or filter statement?

Which argument is used to set the maximum size of the EXTTRAIL or RMTTRAL.

Which Manager Parameter sets will report current lag every hour and write a critical message for any Extract/Replicate with a lag over 60 minutes?

What parameter provides options for compression and encryption?

What GoldenGate process is responsible for capturing changes in the source database?

You have configured and added the extract and Replicate tasks using the direct load method what do you need to do to get the processes up and running?

You are configuring replication between two Oracle tables with the same number of columns, column table names, and data types, but in different orders. For replication purpose can...

How do you control the size of the buffer that contains data extracted from an ASM instance?

How do you control the size of the buffer that contains data extracted from?