1. Home
  2. Oracle
  3. GoldenGate
  4. 1z0-447
  5. Oracle GoldenGate 12c Implementation Essentials Questions and Answers

Pass the Oracle GoldenGate 1z0-447 Questions and answers with CertsForce

 Oracle Exams      Go to Exam Detail      Get Premium Access
Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions
Questions # 1:

Which statement regarding the GoldenGate Data Pump is incorrect?

Options:
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.

Questions # 2:

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

Options:
A.

@GETENV

B.

GGHEADER

C.

GGENVIRONMENT

D.

©TOKEN

Questions # 3:

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

issue related to?

Options:
A.

It is caused byTHREAD and THREADRANGEbeing used with wildcard MAP statements.

B.

It is caused by the thread with the highest thread ID applying barrier transactions.

C.

It is caused by the use of theMAXTRANSOPSparameter.

D.

It is caused by barrier transactions in a Coordinated Replicat.

Questions # 4:

Which option is supported by GoldenGate DDL replication?

Options:
A.

CREATE ROLE

B.

ALTER SYSTEM

C.

ALTER DATABASE

D.

ALTER TABLE SYS

Questions # 5:

You need to locate the position of the oldest unprocessed transaction by using the command INFO EXTRACT SHOWCH. How should you proceed?

Options:
A.

Use the Read Startup Checkpoint.

B.

Use the Read Recovery Checkpoint.

C.

Use the Write Startup Checkpoint.

D.

Use the Read Current Checkpoint.

Questions # 6:

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

Options:
A.

Manager

B.

Extract

C.

Replicat

D.

Both Extract and Replicat

Questions # 7:

Which parameters) would be used for one-time initial replicat?

Options:
A.

PASSTHRU

B.

SOURCEISFILE

C.

CHECKMINUTES

D.

SOURCEISTABLE

E.

SPECIALRUN

Questions # 8:

What software is required prior to running Oracle GoldenGate in a Windows Server environment?

Options:
A.

Oracle Gateway software configured for that particular database platform

B.

JDBC drivers into the GoldenGate home directory

C.

Microsoft Visual C++ 2010 SP1 Redistributable Package

D.

Nothing, configure GoldenGate Jagent for that particular database platform.

Questions # 9:

Which parameter could you use to start an Extract when Manager starts?

Options:
A.

START

B.

BEGIN

C.

AUTOSTART

D.

PROCESS

Questions # 10:

When would you use the PASSTHRU parameter?

Options:
A.

When using a data pump to distribute all of the trail data "as is" to a remote system.

B.

When Extract is processing database transaction logs where you have a remote database connection.

C.

For a SPECIALRUN one-time processing task that is doing an initial load.

D.

When Extract is processing database transaction logs and writing to a local trial that will be read by a local Replicat.

Viewing page 1 out of 3 pages
Viewing questions 1-10 out of questions