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: Jan 08, 2025

Add To Cart

Question 1

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

B : the COLMAP option in the MAP parameter

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

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

Answer: B

Question 2

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

A : ND…CACHEMGR

B : ND…LOGSTATS

C : ND…GETTCPSTATS

D : FO…SHOWCH

Answer: A

Question 3

What is the function of the GoldenGate JAgent?

A : It performs connections via JDBC to run the Veridata comparisons.

B : enables communication between GoldenGate and Monitor, and Enterprise Manager Agent.

C : It reads the database transaction logs.

D : It integrates GoldenGate with Oracle Data Integrator.

Answer: B

Question 4

You want to issue GoldenGate commands from a script. What sequence of steps should you follow to accomplish this?

A : eate a text file that contains the commands that you want to issue, in the order they are to be issued. Run GGSCI ./ input_file, where the file name is the script file.

B : eate a text file that contains the commands that you want to issue, in the order they are to be issued. Enter ggsci < input_file from the command line of the operating system, where the input_file is an OBAY text file

C : eate a text file that contains the commands that you want to issue, in the order they are to be issued. Run GGSCI < input_file, where the file name is an OBEY file.

D : eate a text file that contains the commands that you want to issue, in the order they are to be issued. Enter ggsci ./ input_file from the command line of the operating system, where the file name is the script file.

Answer: B

Question 5

You want to reduce an Integrated Extract’s startup time by using an existing data dictionary. How should you accomplish this?

A : t the shared memory realm of an Integrated Extract with other Integrated Extracts.

B : the SHARE option of the REGISTER EXTRACT command.

C : are the registration ID with other Integrated Extracts.

D : gin the Extract processing at the earliest SCN of the log stream.

Answer: B

Page: 1 / 17

Total 83 Questions | Updated On: Jan 08, 2025

Add To Cart