Free Oracle 1Z0-447 Exam Questions

Become Oracle Certified with updated 1Z0-447 exam questions and correct answers

Page: 1 / 17

Total 83 Questions | Updated On: Mar 24, 2026

Add To Cart

Question 1

Which parameter for GoldenGate 12c enables DDL replication for a Replicat?

A : TARGETDDL

B : GETDDL

C : DDL for Replicat is enabled by default.

D : USEDDL

Answer: C

Question 2

Which Logdump command is used to check how many change records are in the trail file?

A : STATS

B : REPORT

C : REPORTCOUNT

D : COUNT

Answer: D

Question 3

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 the FILTER option in the MAP parameter.

B : Use the COLMAP option in the MAP parameter

C : Do not specify those columns in the ADD TRANDATA command.

D : Use the COLS and COLSEXCEPT options in the TABLE parameter.

Answer: B

Question 4

Your GLOBALS file contains the parameter SYSLOG NONE, but the system logs contain warnings from the Manager. What could be causing this to occur?

A : The GGSCI session was configured incorrectly.

B : The Manager parameter file contains SYSLOG ALL.

C : An Extract or Replicat is overriding GLOBALS with SYSLOG WARN.

D : The user session running Manager is set to log all messages.

Answer: C

Question 5

Which command provides statistics about GoldenGate processes and memory resource utilization?

A : SEND…CACHEMGR

B : SEND…LOGSTATS

C : SEND…GETTCPSTATS

D : INFO…SHOWCH

Answer: A

Page: 1 / 17

Total 83 Questions | Updated On: Mar 24, 2026

Add To Cart