Free Oracle 1z1-447 Exam Dumps Questions & Answers

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

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

You have an issue where all threads are waiting for a specific transaction to be executed first. What is this issue related to?

• A.  It is caused byTHREAD and THREADRANGEbeing used with wildcard MAP
  statements.
• B.  It is caused by the use of theMAXTRANSOPSparameter.
• C.  It is caused by the thread with the highest thread ID applying barrier transactions.
• D.  It is caused by barrier transactions in a Coordinated Replicat.

Which option is supported by GoldenGate DDL replication?

• A.  ALTER TABLE SYS
• B.  CREATE ROLE
• C.  ALTER DATABASE
• D.  ALTER SYSTEM

You are running multiple installations of Oracle GoldenGate on the same Windows server.
How can you differentiate the different Manager services?

• A.  Accept the default service name and manually edit within the Services applet.
• B.  Create aGLOBALSfile for each installation and use theMGRSERVNAMEparameter, with a unique name.
• C.  Multiple Manager services are not allowed on the same Windows server.
• D.  Include the parameterSERVICENAMEin each Manager, with a unique name.

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 that have conflicts
• B.  Triggers and sequences
• C.  Tables with Large Object (LOB) data types
• D.  Tables set with nologging