Online Access Free 1z1-447 Exam Questions

You must synchronize tables with Large Object data types. Which Initial Load method supports this process?

• A.File to database utility
• B.File to Replicat
• C.GoldenGate Direct Load
• D.Direct bulk load to SQL*Loader

Which statement regarding the GoldenGate Data Pump is incorrect?

• A.Data Pump can be used to pump trail records to multiple locations.
• B.Data Pump has distance limitations.
• C.Data Pump uses TCP/IP to route the trail records.
• D.Data Pump is a separate process.

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.Use NODECHECKPONT to cause Replicat to use the checkpoint files as backup and regenerate the checkpoint table.
• C.Restore the target DB from backup, reposition the Extract to a point prior to the corruption, Turn to HANDLECOLLISIONS in the Replicat.
• D.Use the GENCHK utility on the source to restore the checkpoint table from checkpoint files.

You want to increase parallelism for greater integrated Replicat throughput while preserving the original transaction atomicity. How can you achieve this?

• A.You can configure integrated Replicat with theSPECIALRUNparameter.
• B.You can configure integrated Replicat with two parallel apply servers.
• C.You can configure integrated Replicat with two parallel child servers.
• D.You can configure integrated Replicat
  withASSUMETARGETDEFSandSPECIALRUNparameters.

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

• A.when aNOPASSTHRUparameter is used
• B.when aPASSTHRUparameter is used
• C.when look-ups are needed against the source database
• D.when transformations, filtering, and mapping are required