oracle 1z0-447 practice test

You installed GoldenGate on your server, but you received an error when you tried to start GGSCI.
What is the reason for this issue?

• A. The incorrect version of GoldenGate was installed for your CPU architecture.
• B. A license key must be applied first.
• C. GoldenGate Manager was not started first.
• D. TheLD_LIBRARY_PATHvariable to$ORACLE_HOMEwas not set.

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. RMTTRAILis for remote trails andEXTTRAILis for local trails.
• D. Extract is typically used to produce local trail files over a TCP/IP connection.

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

• A. Run thechkpt_db_extracttrail.sqlscript.
• B. Run thechkpt_db_create.sqlscript.
• C. Use theADD Extract Trailcommand.
• D. Use theINFO REPLICATcommand with theSHOWCHoption.
• E. Use theADD CHECKPOINTTABLEcommand.

You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in
the Initial Load file-todatabase utility. How should you configure GoldenGate in order to accomplish
this?

• A. Configure Replicat with theFORMATASCII SQLLOADER OPTION.
• B. Configure Extract with theFORMATSQL SQLLOADER OPTION.
• C. Configure Extract with theFORMATASCII SQLLOADER OPTION.
• D. Configure Replicat with theFORMATXML OPTION.

Your Extract process, which is using an Oracle database, has stopped with uncommitted transactions.
How should you guarantee an efficient recovery after Extract has stopped?

• A. Use theFORCETRANSandPURGEORPHANEDTRANSACTIONSparameters to control the bounded recovery feature of the general Extract checkpointing facility.
• B. Use theWARNLONGTRANSparameter to control the bounded recovery feature of the general Extractcheckpointing facility.
• C. Use theBRparameter to control the bounded recovery feature of the general Extract checkpointing facility.
• D. Use thePURGEORPHANEDTRANSACTIONSparameter to control the bounded recovery feature of the general Extract checkpointing facility.

Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate?

• A. ENABLE_GOLDENGATE_REPLICATION=true
• B. ENABLE_STREAMS_REPLICATION=true
• C. Configure theSTREAMS_POOL_SIZEdatabase parameter
• D. ENABLE_DATABASE_REPLICATION=true

How should you configure Replicat to control how errors are handled in one-way replication?

• A. UseREPERRORin the Replicat parameter file.
• B. UseHANDLECOLLISIONin the Replicat parameter file.
• C. Use Conflict Detection and Resolution in the Replicat parameter file.
• D. UseMAPEXCEPTIONin the Replicat parameter file.

You must implement GoldenGate in a master-to-master configuration. What output from the
profiling scripts should you look for to ensure that your implementation is correct?

• A. Tables set with nologging
• B. Tables with Large Object (LOB) data types
• C. Tables that have conflicts
• D. Triggers and sequences

If multiple GoldenGate processes are accessing a set of trail files, which process should include the
PURGEOLDEXTRACTS parameter to trigger trail file clean-up?

• A. Manager
• B. Replicat
• C. Extract
• D. Extract and Replicat

What is the key purpose of GoldenGate trail files?

• A. They are a persistent storage area for captured transactions.
• B. They are configuration files for the GoldenGate processes.
• C. They are checkpoint files for the GoldenGate processes.
• D. They are database auditing logs where GoldenGate captures changes.