1Z0-539 Exam Questions

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? Oracle 1Z0-539 Exam

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 GGSCI command(s) show all available information on both read and write checkpoint for an Extract? Example: 1 INFO EXTRACT <group name> Example: 2 INFO EXTRACT <group name>, D...

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

What is GGSCI an acronym for? Oracle 1Z0-539 Exam

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?

Oracle 1Z0-539 Exam 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 row...

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?