Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Certensure Logo
  1. Home
  2. Oracle
  3. GoldenGate
  4. 1z0-447 - Oracle GoldenGate 12c Implementation Essentials

Oracle 1z0-447 Oracle GoldenGate 12c Implementation Essentials Exam Practice Test

Demo: 10 questions
Total 72 questions
Get 1z0-447 Full Access Download 1z0-447 PDF

Oracle GoldenGate 12c Implementation Essentials Questions and Answers

Question 1

Which statement correctly explains when you would use ASSUMETARGETDEFS?

Options:

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

Question 2

What is the name and the location of the file that lists the key values used by extract for encryptions and Server Collector for decryption?

Options:

A.

KEYGEN file in the GoldenGate data location

B.

COBGEN file in the GoldenGate installation location

C.

GGSKEY file in the GoldenGate data location

D.

GGSKEY file in the GoldenGate installation location

E.

ENCKEYS file in the GoldenGate installation location

Question 3

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.

Question 4

Which method in GoldenGate should you use to undo DML changes previously made to a target database?

Options:

A.

Run Extract and Replicat from the command line.

B.

Use Extract and Replicat with the GoldenGate Logdump utility.

C.

Run the Reverse Utility on the target database transaction logs.

D.

Use Extract and Replicat with the GoldenGate Reverse utility.

Question 5

You have discovered that an OGG checkpoint table has become corrupted. What is you best strategy to recover From this?

Options:

A.

Use the CONVCHK utility on the target to restore the checkpoint table from checkpoint files.

B.

Restore the target DB from backup, reposition the Extract to a point prior to the corruption, Turn to HANDLECOLLISIONS in the Replicat.

C.

Use NODECHECKPONT to cause Replicat to use the checkpoint files as backup and regenerate the checkpoint table.

D.

Use the GENCHK utility on the source to restore the checkpoint table from checkpoint files.

Question 6

Which option is an invalid GLOBALS parameter?

Options:

A.

DISCARDFILE

B.

GGSCHEMA

C.

MGRSERVNAME

D.

CHECKPOINTTABLE

Question 7

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

Options:

A.

DEFERAPPLYINTERVAL

B.

BATCHSQL

C.

ASSUMETARGETDEFS

D.

SPECIALRUN

Question 8

How does Replicate know the structure of the source tables when the target has a different layout?

Options:

A.

GoldenGate trail file contains the metadata of incoming data

B.

Replicat uses an ODBC connection to connect to the source system tables

C.

Parameter file contains table layouts

D.

Discard file contains table layouts

E.

Source Definitions file contains table layouts

Question 9

Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?

Options:

A.

The Extract will revert to single-row fetch mode, and then resume array fetches afterwards.

B.

The Extract will revert to single-row fetch mode for all tables.

C.

The Extract will abend unless LOBMEMORY is increased.

D.

The Extract will perform poorly due to paging unless LOBMEMORY is increased.

Question 10

Which option is supported by GoldenGate DDL replication?

Options:

A.

CREATE ROLE

B.

ALTER SYSTEM

C.

ALTER DATABASE

D.

ALTER TABLE SYS

Load More 1z0-447 Questions
Demo: 10 questions
Total 72 questions
Get 1z0-447 Full Access Download 1z0-447 PDF