Which three are the responsibility of the MGR process? (Select three.)
A. Process management
B. Trail File management
C. Data movement
D. Receive or route requests from the UI E. Trigger execution
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 the STREAMS_POOL_SIZEdatabase parameter
D. ENABLE_DATABASE_REPLICATION=true
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
Which statement regarding the GoldenGate Data Pump is incorrect?
A. Data Pump is a separate process.
B. Data Pump can be used to pump trail records to multiple locations.
C. Data Pump has distance limitations.
D. Data Pump uses TCP/IP to route the trail records.
Which Logdump command is used to check how many change records are in the trail file?
A. STATS
B. REPORT
C. REPORTCOUNT
D. COUNT
You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you differentiate the different Manager services?
A. Create a GLOBALS file for each installation and use the MGRSERVNAMEparameter, with a unique name.
B. Include the parameter SERVICENAME in each Manager, with a unique name.
C. Accept the default service name and manually edit within the Services applet.
D. Multiple Manager services are not allowed on the same Windows server.
GoldenGate has cached long-running open transactions to disk for an Oracle database. Where can you locate them?
A. in the checkpoint file area
B. in the trail files area
C. in the server temporary file system
D. in the bounded recovery area
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 the OVERWRITE command.
B. Include the USEDELTA command.
C. Include the ADDTRANDATA command.
D. Include the UPDATAROWEXISTScommand.
You want to map exception to an exceptions table using the MAPEXCEPTION option of the MAP parameter. When should you proceed?
A. when the names of both the source and target tables in the MAP statement are wildcarded
B. when there is a unique restriction on the exception table
C. when there is a primary key on the exception table
D. when there is a failed operation logged on the source table
Which capability does GoldenGate support?
A. file-based Capture
B. asynchronous Capture and Delivery of committed DML transactions
C. two-phase commit operations from application interfaces
D. Synchronous transaction Capture from application interfaces
