1Z0-447 Oracle Exam Questions and Free Practice Test

Question 13

Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.

A. Run thechkpt_db_extracttrail.sqlscript.

B. Run thechkpt_db_create.sqlscript.

C. Use theADD Extract Trailcommand.

D. Use theINFO REPLICATcommand with theSHOWCHoption.

E. Use theADD CHECKPOINTTABLEcommand.

Correct Answer:BE

Question 14

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

A. Use the Read Startup Checkpoint.

B. Use the Read Recovery Checkpoint.

C. Use the Write Startup Checkpoint.

D. Use the Read Current Checkpoint.

Correct Answer:B

Question 15

A database that requires replication contains sensitive data that is not required on the target. How should you prevent this sensitive data from being replicated?

A. Use theFILTERoption in theMAPparameter.

B. Use theCOLMAPoption in theMAPparameter.

C. Do not specify those columns in theADD TRANDATAcommand.

D. Use theCOLSandCOLSEXCEPToptions in theTABLEparameter.

Correct Answer:B

Question 16

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?

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

Correct Answer:E

Question 17

You need to look up table definitions in a file. Which Replicat parameter should you use?

A. ASSUMETARGETDEFS

B. COLMATCH

C. SOURCEDEFS

D. MAP

Correct Answer:C

Question 18

Which three are required to correctly configure an OGG?

A. A maximum file size

B. An extract process

C. A trail file identifier

D. Designation as local or remote

Correct Answer:BCD

START 1Z0-447 EXAM