1Z0-447 Online Practice Questions and Answers

You must locate the next good record header in a Logdump file. How should you do this?

A. Logdump >SCANFORGHDR

B. Logdump > GHDR ON

C. Logdump > SCANFORENDTRANS

D. Logdump > SCANFORHEADER

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.

Which statement is valid for DDL replication?

A. GoldenGate User Exits are not supported for DDL.

B. Source and target objects can be different.

C. Target objects can be different from source when using SOURCEDEFS in Replicat.

D. It can use WILDCARDRESOLVE IMMEDIATE.

You are running multiple installations of Oracle GoldenGate on the same Windows server. How can you differentiate the different Manager services?

A. Create a GLOBALS file for each installation and use the MGRSERVNAMEparameter, with a unique name.

B. Include the parameter SERVICENAME in each Manager, with a unique name.

C. Accept the default service name and manually edit within the Services applet.

D. Multiple Manager services are not allowed on the same Windows server.

GoldenGate has cached long-running open transactions to disk for an Oracle database. Where can you locate them?

A. in the checkpoint file area

B. in the trail files area

C. in the server temporary file system

D. in the bounded recovery area

Which method in GoldenGate should you use to undo DML changes previously made to a target database?

A. Run Extract and Replicat from the command line.

B. Use Extract and Replicat with the GoldenGate Logdump utility.

C. Run the Reverse Utility on the target database transaction logs.

D. Use Extract and Replicat with the GoldenGate Reverse utility.

You must prepare the source database to send redo to the mining database. What sequence of steps should you follow to accomplish this?

A. Ensure that the source database is running with the required compatibility. Use the TRANSLOGOPTIONS parameter, set up redo transport at the source database, and enable the downstream destination.

B. Ensure that the source database is running with the required compatibility. Set DB_CONFIG at the source database. Set up redo transport at the source database.

C. Set DG_CONFIG at the source database and enable the downstream destination.

D. Ensure that the source database is running with the required compatibility. Set DG_CONFIG at the source database. Set up redo transport at the source database and enable the downstream destination.

An integrated Replicat is running with PARALLELISM set to four, yet you discover that for a series of large operations, only one apply server is processing the operations. What is the reason for this issue?

A. Operations are grouped into one apply server automatically based on GROUPTRANSOPS.

B. Parallelism for an Integrated Replicat cannot exceed one.

C. The operations for a particular table are pinned to a specific apply server.

D. The operations are all part of one transaction.

Which three statements are true regarding GoldenGate password encryption? (Choose three.)

A. An encrypted password cannot be generated using a user-defined key

B. An encrypted password can be generated using the default key

C. An encrypted password can be generated using a user-defined key

D. A password cannot be encrypted and pasted into a parameter file

E. A password can be encrypted and pasted into a parameter file

Which transactions are captured if you ADD EXTRACT with BEGIN NOW at 1:00 PM, START EXTRACT at 2:00 PM?

A. Transactions that started at or after 1:00 PM

B. Transactions that started before 1:00 PM and committed after 2:00 PM

C. Only transactions that started before 1:00 PM and committed after 1:00 PM

D. Only transactions that started at or after 2:00 PM