What is the function of the GoldenGate JAgent?

What is the function of the GoldenGate JAgent? A. It performs connections via JDBC to run the Veridata comparisons. B. It enables communication between GoldenGate and Monitor, and Enterprise Manager Agent. C. It reads the database transaction logs. D. It integrates GoldenGate with Oracle Data Integrator. Show Answer

Read More

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

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. Explanation:Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GIMSS/system_requirements.htm#GIMSS182 Show Answer

Read More

Which statement is valid for DDL replication?

Which statement is valid for DDL replication? A. GoldenGate User Exits are not supported for DDL. B. Source and target objects can be different. C. Target objects can be different from source when using SOURCEDEFS in Replicat. D. It can use WILDCARDRESOLVE IMMEDIATE. Show Answer

Read More

Identify the correct statement regarding Trails.

Identify the correct statement regarding Trails. A. Extract and Pump are different OS level executable binary files. B. Extracts cannot perform filtering, mapping, and transformations. C. RMTTRAIL is for remote trails and EXTTRAIL is for local trails. D. Extract is typically used to produce local trail files over a TCP/IP connection. Show Answer

Read More

Replicat makes checkpoints in the trail file to mark its last read position.

Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables. A. Run the chkpt_db_extracttrail.sql script. B. Run the chkpt_db_create.sql script. C. Use the ADD Extract Trail command. D. Use the INFO REPLICAT command with the SHOWCH option. E. Use the ADD CHECKPOINTTABLE command. Explanation:Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_ogg_checkpts.htm#GWUAD972 […]

Read More

How should you configure GoldenGate in order to accomplish this?

You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-to¬≠database utility. How should youconfigure GoldenGate in order to accomplish this? A. Configure Replicat with the FORMATASCII SQLLOADER OPTION. B. Configure Extract with the FORMATSQL SQLLOADER OPTION. C. Configure Extract with the FORMATASCII SQLLOADER […]

Read More

How should you guarantee an efficient recovery after Extract has stopped?

Your Extract process, which is using an Oracle database, has stopped with uncommitted transactions. How should you guarantee an efficient recovery after Extracthas stopped? A. Use the FORCETRANS and PURGEORPHANEDTRANSACTIONS parameters to control the bounded recovery feature of the general Extract checkpointing facility. B. Use the WARNLONGTRANS parameter to control the bounded recovery feature of […]

Read More