Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-447 - Oracle GoldenGate 12c Implementation Essentials

Oracle 1z0-447 Premium Access     Download Demo    
Page: 2 / 3
Total 72 questions

You must synchronize tables with Large Object data types. Which Initial Load method supports this process?

A.

File to Replicat

B.

GoldenGate Direct Load

C.

File to database utility

D.

Direct bulk load to SQL*Loader

You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you

differentiate the different Manager services?

A.

Create aGLOBALSfile for each installation and use theMGRSERVNAMEparameter, with a unique name.

B.

Include the parameterSERVICENAMEin 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.

Veridata has completed the initial comparison and you want to view the rows that appear to be out-of-sync. How can you do this?

A.

View the maybe out-of-sync (MOOS) queue.

B.

View the Veridata log file.

C.

View the confirm-out-of-sync (COOS) queue.

D.

View the Veridata Agent repository.

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 parameter could you use to start an Extract when Manager starts?

A.

START

B.

BEGIN

C.

AUTOSTART

D.

PROCESS

You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-to–database 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.

By default which type of operations are captured by extract?

A.

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

B.

Inserts, compresses, and updates

C.

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

D.

Inserts only

E.

Inserts, updates, and deletes

Which two are valid macros?

A.

Option A

B.

Option B

C.

Option C

D.

Option D

Your Replicat performance seems slow. Which Replicat parameter can be used to improve performance?

A.

DEFERAPPLYINTERVAL

B.

BATCHSQL

C.

ASSUMETARGETDEFS

D.

SPECIALRUN

Which statement correctly explains when you would use ASSUMETARGETDEFS?

A.

The target tables are already created.

B.

Only the fields in the target tables are mapped.

C.

The source and target tables have identical data structure.

D.

You have specified wildcards in either the TABLE or MAP parameters