1Z0-481 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?

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______.

Which utility is responsible for generating source data definitions files?

Which statement correctly describes GoldenGate Extract and Replicat process reports?

Which statements are true for a two-node, active-active OGG replication configuration? - Both databases may be live and processing transactions. - The two databases must be homogen...

What is GGSCI an acronym for?

You have a requirement to extract changes from an oracle 10g database without installing or running any GoldenGate processes on the host server. To accomplish this, which GoldenGat...

Where is user token data stored?

What command is issued to alter Replicat to start processing trail number 10 at relative byte address 100345?

Neither your source, nor your target table has a primary key, and you have not designated KEYCOLS. How will the Replicat proceed to identify matching target rows to update or delet...

Which best describes the function of OGG user tokens?

What could you use to formal 123456789 to format of social security number 123-456-789?

Replicat is responsible for which three options?

What GoldenGate process writes to RMTTRAILS?

How does Replicat know the structure of the source tables when the target has a different layout?

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?

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

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 statements are true of goldenGate password encryption? 1. A password can be encrypted and pasted into a parameter file. 2. An encrypted password can be generated using the de...

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 database platform does GoldenGate not natively support?