1z0-447 sample questions

Question 1

What software is required prior to running Oracle GoldenGate in a Windows Server environment?

Accepted Answer

Microsoft Visual C++2010 SP1 Redistributable Package

Answer

Oracle Gateway software configured for that particular database platform

Answer

JDBC drivers into the GoldenGate home directory

Answer

Nothing, configure GoldenGate Jagent for that particular database platform.

Question 2

Which statement regarding the GoldenGate Data Pump is incorrect?

Accepted Answer

Data Pump is a separate process.

Answer

Data Pump can be used to pump trail records to multiple locations.

Answer

Data Pump has distance limitations.

Answer

Data Pump uses TCP/IP to route the trail records.

Question 3

You must implement GoldenGate in a secure environment. How should you proceed in order to protect GoldenGate data from theft?

Accepted Answer

Ensure that table-level Transparent Data Encryption is implemented.

Answer

Implement trail file encryption.

Answer

Ensure that passwords are encrypted.

Answer

Ensure that network communications are encrypted.

Question 4

You are migrating from a legacy database server to Exadata, which requires you to use different versions of GoldenGate. What do you need to configure to ensure that backwards replication works?

Accepted Answer

The Replicat with the FORMAT RELEASE parameter.

Answer

The Extract with the FORMAT RELEASE parameter.

Answer

The Extract to write directly to the remote trail.

Answer

The collector with the FORMAT RELEASE parameter.

Question 5

Which statement is valid for DDL replication?

Accepted Answer

Source and target objects can be different.

Answer

GoldenGate User Exits are not supported for DDL.

Answer

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

Answer

It can use WILDCARDRESOLVE IMMEDIATE.

Question 6

Which is an incorrect syntax for connecting to a source or target database by an Extract or Replicat?

Accepted Answer

SOURCEDB SourceDSN

Answer

TARGETDB TargetDSN USERID samplelD PASSWORD samplepword

Answer

SOURCEDB sampleDB USERID samplelD PASSWORD samplepword

Answer

TARGETDB samplelD samplepword

Question 7

Which database setting for the Oracle 11.2.0.4 database is required to enable Oracle GoldenGate?

Accepted Answer

ENABLE_GOLDENGATE_REPLICATION=true

Answer

ENABLE_STREAMS_REPLICATION=true

Answer

Configure the STREAMS_POOL_SIZE database parameter

Answer

ENABLE_DATABASE_REPLICATION=true

Question 8

Which syntax would you use in an OBEY script to stop a process without waiting for user input?

Accepted Answer

stop * !

Answer

stop* noinput

Answer

stop immediate *

Answer

stop force*

Question 9

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

Accepted Answer

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.

Answer

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.

Answer

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.

Answer

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 namei s the script file.

Question 10

You have a source table with a PRODUCTJD column and a target table with PRODUCT_DESCRIPTION column. On the target database, there is a lookup table containing product codes and corresponding descriptions.

What should you use to look up the PRODUCT_DESCRIPTION for each transaction?

Accepted Answer

SQLEXEC ()

Answer

DBLOOKUP ()

Answer

DBLOGIN ()

Answer

SQLLOOKUP ()

Free 1z0-447 sample questions