1z0-447 Sample Questions Answers

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

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

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

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

File to Replicat

GoldenGate Direct Load

File to database utility

Direct bulk load to SQL*Loader

in the checkpoint file area

in the trail files area

in the server temporary file system

in the bounded recovery area

DEFERAPPLYINTERVAL

BATCHSQL

ASSUMETARGETDEFS

SPECIALRUN

TARGETDB TargetDSN USERID sampleID PASSWORD samplepword

SOURCEDB SourceDSN

SOURCEDB sampleDB USERID sampleID PASSWORD samplepword

TARGETDB sampleID samplepword

1000

100

O

By default, messages are not compressed.

ASCII:ASCII format

INPUT ASCII: from 1to 127 representing ASCII characters

SQL: SQL statements

CDF: Canonical Data format

XML: XML statement

ASSUMETARGETDEFS

COLMATCH

SOURCEDEFS

MAP

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

Inserts, compresses, and updates

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

Inserts only

Inserts, updates, and deletes

DISCARDFILE

GGSCHEMA

MGRSERVNAME

CHECKPOINTTABLE

Extract and Pump are different OS level executable binary files.

Extracts cannot perform filtering, mapping, and transformations.

RMTTRAILis for remote trails andEXTTRAILis for local trails.

Extract is typically used to produce local trail files over a TCP/IP connection.

Manager

Replicat

Extract

Extract and Replicat

Checkpointing

Sub-second latency

Two-phase commits

Transactional integrity

UseREPERRORin the Replicat parameter file.

UseHANDLECOLLISIONin the Replicat parameter file.

Use Conflict Detection and Resolution in the Replicat parameter file.

UseMAPEXCEPTIONin the Replicat parameter file.

Data Pump is a separate process.

Data Pump can be used to pump trail records to multiple locations.

Data Pump has distance limitations.

Data Pump uses TCP/IP to route the trail records.

Oracle Gateway software configured for that particular database platform

JDBC drivers into the GoldenGate home directory

Microsoft Visual C++ 2010 SP1 Redistributable Package

Nothing, configure GoldenGate Jagent for that particular database platform.

Tables set with nologging

Tables with Large Object (LOB) data types

Tables that have conflicts

Triggers and sequences

MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (2, 3, AccountID));

MAP sales.acct, TARGET sales.acct, FILTER (@RANGE (1, 3, ID));

TABLE fin.Sales, FILTER (@RANGE (1, 2));

FILTER (@RANGE (2, 2, AccountID));

FILTER (@RANGE 2, 2, ID);