1Z0-447 Free Practice Test

GoldenGate has cached long-running open transactions to disk for an Oracle database. Where can you locate them?

1. A. in the checkpoint file area
2. B. in the trail files area
3. C. in the server temporary file system
4. D. in the bounded recovery area

Correct Answer: C

What Oracle GoldenGate feature provides recoverability without loss of transactions?

1. A. Checkpointing
2. B. Sub-second latency
3. C. Two-phase commits
4. D. Transactional integrity

Correct Answer: A

Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.

1. A. Run thechkpt_db_extracttrail.sqlscript.
2. B. Run thechkpt_db_create.sqlscript.
3. C. Use theADD Extract Trailcommand.
4. D. Use theINFO REPLICATcommand with theSHOWCHoption.
5. E. Use theADD CHECKPOINTTABLEcommand.

Correct Answer: BE

You need to configure the source database, target database, and Oracle GoldenGate for conflict detection and resolution (CDR). You want the full before image of each record, but your database does not provide a before image in the log record and must be configured to do so with supplemental logging.
How should you proceed?

1. A. Include theOVERWRITEcommand.
2. B. Include theUSEDELTAcommand.
3. C. Include theADD TRANDATAcommand.
4. D. Include theUPDATAROWEXISTScommand.

Correct Answer: C

You must configure GoldenGate parameter files for conflict resolution and want to be sure that the before values are compared with current values in the target database to detect update and delete conflicts.
How should you accomplish this?

1. A. Use theCOMPCOLSwith theGETUPDATEBEFORESoption of the MAP parameter in the Replicatparameter file to specify columns that are to be used with before values in the ReplicatWHERE clause.
2. B. Use theCOMPARECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.
3. C. Use theGETUPDATEBEFORESoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.
4. D. Use theGETBEFORECOLSoption of the MAP parameter in the Replicat parameter file to specify columns that are to be used with before values in the ReplicatWHEREclause.

Correct Answer: B