Oracle 1Z0-447 Free Practice Questions

Question No: 3

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

A. Oracle Gateway software configured for that particular database platform

B. JDBC drivers into the GoldenGate home directory

C. Microsoft Visual C++ 2010 SP1 Redistributable Package

D. Nothing, configure GoldenGate Jagent for that particular database platform.

View Answer

Question No: 4

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 usingSOURCEDEFSin Replicat.

D. It can useWILDCARDRESOLVE IMMEDIATE.

View Answer

Question No: 5

When is a Pump not required to connect to a source database?

A. when transformations, filtering, and mapping are required

B. when look-ups are needed against the source database

C. when aPASSTHRUparameter is used

D. when aNOPASSTHRUparameter is used

View Answer

Question No: 6

In which process should you configure the warning for long-running transactions?

A. Jagent

B. Extract

C. Replicat

D. Manager

View Answer

Question No: 7

You want to generate an extract file or trail in a non-GoldenGate canonical format like those used in the Initial Load file-tou2013database utility. How should you configure GoldenGate in order to accomplish this?

A. Configure Replicat with theFORMATASCII SQLLOADER OPTION.

B. Configure Extract with theFORMATSQL SQLLOADER OPTION.

C. Configure Extract with theFORMATASCII SQLLOADER OPTION.

D. Configure Replicat with theFORMATXML OPTION.

View Answer

Question No: 8

When would you use the PASSTHRU parameter?

A. When using a data pump to distribute all of the trail data "as is" to a remote system.

B. When Extract is processing database transaction logs where you have a remote database connection.

C. For a SPECIALRUN one-time processing task that is doing an initial load.

D. When Extract is processing database transaction logs and writing to a local trial that will be read by a local Replicat.

View Answer

Question No: 9

You must synchronize tables with Large Object data types. Which Initial Load method supports this process?

A. File to Replicat

B. GoldenGate Direct Load

C. File to database utility

D. Direct bulk load to SQL*Loader

View Answer

Question No: 10

Which option is supported by GoldenGate DDL replication?

A. CREATE ROLE

B. ALTER SYSTEM

C. ALTER DATABASE

D. ALTER TABLE SYS

View Answer

Question No: 11

You must implement GoldenGate in a master-to-master configuration. What output from the profiling scripts should you look for to ensure that your implementation is correct?

A. Tables set with nologging

B. Tables with Large Object (LOB) data types

C. Tables that have conflicts

D. Triggers and sequences

View Answer

Question No: 12

Select four Oracle GoldenGate use cases.

A. real-time discovery

B. real-time data warehousing

C. offload reporting

D. zero downtime upgrades and migrations

E. backup and recovery

F. data center load balancing by using multi-master replication

View Answer