Free Online Oracle 1Z0-447 Practice Test

Prepare Your Oracle 1Z0-447 Exam Questions with Free online 1Z0-447 Practice Test. Get Brilliant Oracle GoldenGate 12c Implementation Essentials Exam Results with Valid 1Z0 447 Exam Dumps.

Page: 1 / 17

Total 83 Questions | Updated On: Apr 25, 2024

Question 1

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

Question 2

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 3

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

A : Create 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 : Create 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 : Create 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 : Create 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 4

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 5

If multiple GoldenGate processes are accessing a set of trail files, which process should include the PURGEOLDEXTRACTS parameter to trigger trail file clean-up?

A : Manager

B : Replicat

C : Extract

D : Extract and Replicat

Answer: A

Page: 1 / 17

Total 83 Questions | Updated On: Apr 25, 2024