Question No: 1

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

A. Use the CONVCHK utility on the target to restore the checkpoint table from checkpoint files.

B. Restore the target DB from backup, reposition the Extract to a point prior to the corruption, Turn to HANDLECOLLISIONS in the Replicat.

C. Use NODECHECKPONT to cause Replicat to use the checkpoint files as backup and regenerate the checkpoint table.

D. Use the GENCHK utility on the source to restore the checkpoint table from checkpoint files.

View Answer

Question No: 2

Select four Oracle GoldenGate use cases.

A. real-time discovery

B. real-time data warehousing

C. offload reporting

D. zero downtime upgrades and migrations

E. backup and recovery

F. data center load balancing by using multi-master replication

View Answer

Question No: 3

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

A. START

B. BEGIN

C. AUTOSTART

D. PROCESS

View Answer

Question No: 4

By default which type of operations are captured by extract?

A. Inserts, updates, deletes, and table operations such as CREATE TABLE

B. Inserts, compresses, and updates

C. Inserts, updates, deletes, and table operations such as ADD COLUMN

D. Inserts only

E. Inserts, updates, and deletes

View Answer

Question No: 5

Identify two correct statements regarding GoldenGate supported features.

A. GoldenGate supports network encryption and compression.

B. GoldenGate supports DML and DDL replication for all supported databases.

C. GoldenGate for Oracle supports Exadata Hybrid Columnar Compression as a source.

D. GoldenGate for SQLServer supports only SQLServer Standard Edition as a source.

View Answer

Question No: 6

You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?

A. It is caused byTHREAD and THREADRANGEbeing used with wildcard MAP statements.

B. It is caused by the thread with the highest thread ID applying barrier transactions.

C. It is caused by the use of theMAXTRANSOPSparameter.

D. It is caused by barrier transactions in a Coordinated Replicat.

View Answer

Question No: 7

What software is required prior to running Oracle GoldenGate in a Windows Server environment?

A. Oracle Gateway software configured for that particular database platform

B. JDBC drivers into the GoldenGate home directory

C. Microsoft Visual C++ 2010 SP1 Redistributable Package

D. Nothing, configure GoldenGate Jagent for that particular database platform.

View Answer

Question No: 8

What is the default format for a GoldenGate trail?

A. ASCII:ASCII format

B. INPUT ASCII: from 1to 127 representing ASCII characters

C. SQL: SQL statements

D. CDF: Canonical Data format

E. XML: XML statement

View Answer

Question No: 9

When would you use the PASSTHRU parameter?

A. When using a data pump to distribute all of the trail data "as is" to a remote system.

B. When Extract is processing database transaction logs where you have a remote database connection.

C. For a SPECIALRUN one-time processing task that is doing an initial load.

D. When Extract is processing database transaction logs and writing to a local trial that will be read by a local Replicat.

View Answer

Question No: 10

When is a Pump not required to connect to a source database?

A. when transformations, filtering, and mapping are required

B. when look-ups are needed against the source database

C. when aPASSTHRUparameter is used

D. when aNOPASSTHRUparameter is used

View Answer