Oracle GoldenGate 12c Implementation Essentials (1z0-447) Free Practice Test

Question 1

You must synchronize the starting point for Replicat with the restore point of the target database. How should you accomplish this?

A. Use the command optionATCSN.

B. Use the command optionUNTIL CANCEL.

C. Use the command optionAFTERCSN.

D. Use the command optionRESUME.

Correct Answer: C

Question 2

Which three are types of encryption supported by OGG?

A. Trial file encryption

B. Parameter file encryption

C. Message encryption

D. Password

Correct Answer: A,B,D

Question 3

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

A. SPECIALRUN

B. DEFERAPPLYINTERVAL

C. BATCHSQL

D. ASSUMETARGETDEFS

Correct Answer: C

Question 4

Which statement is valid for DDL replication?

A. It can useWILDCARDRESOLVE IMMEDIATE.

B. GoldenGate User Exits are not supported for DDL.

C. Source and target objects can be different.

D. Target objects can be different from source when usingSOURCEDEFSin Replicat.

Correct Answer: C

Question 5

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, and deletes

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

E. Inserts only

Correct Answer: C

Question 6

Ideally which process should be configured purge old trial files?

A. Extract

B. Manager

C. Pump

D. Replicat

Correct Answer: B

Question 7

Which three describe a valid OGG Event Action?

A. Run a shell command

B. Purge old trail files

C. Write a checkpoint before and/or after writing the record to the trail.

D. Stop the process

Correct Answer: A,C,D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

You installed GoldenGate on your server, but you received an error when you tried to start GGSCI. What is the reason for this issue?

A. TheLD_LIBRARY_PATHvariable to$ORACLE_HOMEwas not set.

B. GoldenGate Manager was not started first.

C. A license key must be applied first.

D. The incorrect version of GoldenGate was installed for your CPU architecture.

Correct Answer: D

Welcome to TestSimulate

Oracle GoldenGate 12c Implementation Essentials (1z0-447) Free Practice Test