Online Access Free 1z0-447 Exam Questions

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?

• A.Include theOVERWRITEcommand.
• B.Include theADD TRANDATAcommand.
• C.Include theUSEDELTAcommand.
• D.Include theUPDATAROWEXISTScommand.

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.GoldenGate Manager was not started first.
• C.TheLD_LIBRARY_PATHvariable to$ORACLE_HOMEwas not set.
• D.A license key must be applied first.

Identify the correct statement regarding Trails.

• A.RMTTRAILis for remote trails andEXTTRAILis for local trails.
• B.Extract and Pump are different OS level executable binary files.
• C.Extract is typically used to produce local trail files over a TCP/IP connection.
• D.Extracts cannot perform filtering, mapping, and transformations.

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.

Which could be used to map a value stored in a user token to a target column?

• A.@GETENV
• B.TOKEN
• C.GGHEADER
• D.GGENVIRONMENT