1Z0-481 Exam Questions

What is the GoldenGate command line interface?

When implementing GoldenGate on a 11gR2 Oracle database and after running the GoldenGate Database profiling script, you discover that certain objects are compressed, what should yo...

Which Replicat parameter is used when looking up table definitions in a file?

Select the function that stores environmental values.

Select the statement that is supported by OGG DDL Replication.

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?

What three are valid responsibilities of the OGG Manager?

You have implemented multi-master Oracle/Oracle replication without a provision to exclude transactions committed by a Replicat process. What errors are likely to occur?

What three types of information are reported in discard file?

Which command forces a running Extract to close the current trial and start writing to the next trial sequence number?

To meet a business requirement for latency, Carlos wants to break long-running source transactions into shorter commits on the target database with the replicate parameter MAXTRANS...

In GoldenGate terms, what is the definition of Extract lag?

Which OGG process (es) can change data in database?

You have a source installation of OGG l0 that includes an initial extract and datapump to provide a remote trail formatted for a GoldenGate 9.5 Replicat process to consume, which p...

You are responsible for replication between your central office and twelve regional nodes. What is the best product for you to use to actively monitor thirteen GoldenGate TDM insta...

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

What is the default format for a GoldenGate trail?

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?

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