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 must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?

A. Oracle Goldengate for Big Data

B. Oracle Goldengate Application Adapters

C. Oracle Goldengate Veridata

D. Oracle Data Integrator Adapters

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

You are implementing GoldenGate monitoring via the Enterprise Manager Plug-In. When you start JAgent, it fails with “ajava.lang.Exception: One or more Java Agent properties in Config.propertiesare not defined properly”.

What is the first thing to check?

A. if The Enterprise Manager Agent is running

B. if the JAgent has been enabled in the GoldenGate Manager

C. if the agent type is set to OEM in JAgent properties

D. if the Oracle Wallet has been created for the JAgent

Which option is supported by GoldenGate DDL replication?

A. CREATE ROLE

B. ALTER SYSTEM

C. ALTER DATABASE

D. ALTER TABLE SYS

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

A. Implement trail file encryption.

B. Ensure that passwords are encrypted.

C. Ensure that network communications are encrypted.

D. Ensure that table-level Transparent Data Encryption is implemented.

Which GLOBALS parameter is required to initially enable monitoring?

A. JAGENTMONITORING

B. ENABLEMONITORING

C. ENABLEOEMMONITORING

D. CHECKMONITORING

Which combination of DBMS, Extract, and GoldenGate version is required to avoid using a DDL trigger?

A. Oracle Database 11.2.0.3 or greater, Integrated Extract, and GoldenGate 12.1 or greater

B. any version of Oracle Database, Integrated Extract, and GoldenGate 11.2 or greater

C. Oracle Database 11.2.0.4 or greater, Integrated Extract, and GoldenGate 12.1 or greater

D. Oracle Database 12c or greater, Integrated Extract, and GoldenGate 11.2 or greater

You need to configure the source database, target database, and Oracle GoldenGate for conflict detection and resolution (CDR). You want the full before image of each record, but your database does not provide a before image in the log record and must be configured to do so with supplemental logging.

How should you proceed?

A. Include the OVERWRITE command.

B. Include the USEDELTA command.

C. Include the ADDTRANDATA command.

D. Include the UPDATAROWEXISTScommand.

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

A. TARGETDB TargetDSN USERID sampleID PASSWORD samplepword

B. SOURCEDB SourceDSN

C. SOURCEDB sampleDB USERID sampleID PASSWORD samplepword

D. TARGETDB sampleID samplepword

Your GLOBALS file contains the parameter SYSLOG NONE, but the system logs contain warnings from the Manager. What could be causing this to occur?

A. The GGSCI session was configured incorrectly.

B. The Manager parameter file contains SYSLOG ALL.

C. An Extract or Replicat is overriding GLOBALS with SYSLOG WARN.

D. The user session running Manager is set to log all messages.

Which Replicat MAP parameter and syntax should be used to detect an update conflict on the EURO.SEAT_RESV table and resolve the conflict by determining which record has the oldest LAST_UDATE value?

A. MAP us.seat_resv, TARGET euro.seat_resv, COLMAP (ON UPDATE KEYINCLUDING(last_update)), RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX(last_update)));

B. MAP us.seat_resv, TARGET euro.seat_resv, COLMAP (ON UPDATE KEYINCLUDING(last_update)), RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMIN(last_update)));

C. MAP us.seat_resv, TARGET euro.seat_resv, COMPARECOLS (ON UPDATE KEYINCLUDING(last_update)), RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMIN(last_update)));

D. MAP us.seat_resv, TARGET euro.seat_resv, COMPARECOLS (ON INSERT KEYINCLUDING(last_update)), RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, USEDELTA(last_update)));

You have a source table with a PRODUCT_ID 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?

A. SQLEXEC ( )

B. DBLOOKUP ( )

C. DBLOGIN ( )

D. SQLLOOKUP ( )

You need to manually patch Oracle GoldenGate source and targets. How should you proceed?

A. Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump (if used) and Replicat are finished processing the data in their respective trails. Stop the data pump and Replicat. Apply the patch on the target. If the patches changed table definitions, run DEFGEN for the source tables to generate updated source definitions, and then replace the old definitions with the new ones in the existing source definitions file on the target system. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.

B. Stop access to the source database. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source and on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.

C. Stop access to the source and target databases. Allow Extract to finish capturing the transaction data that remains in the transaction log and stop Extract. Start applying the patch on the source. Wait until the data pump (if used) and Replicat are finished processing the data in their respective trails. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.

D. Stop access to the source and target databases. Start applying the patch on the source. Stop the data pump and Replicat. Apply the patch on the target. Start the Oracle GoldenGate processes whenever you are ready to begin capturing user activity again.

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