Oracle Oracle Certifications 1Z0-447 Questions & Answers

• Question 11:

  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)));

  Correct Answer: C

  Reference: http://www.oracle.com/technetwork/middleware/gg-activeactive-11-2009-159996.pdf

• Question 12:

  What sequence of steps should you follow to add a data pump that reads from a local trail?

  A. In GGSCI, on the source system, issue the command: ADDEXTRACTgroup name, TRAILSOURCE trail name.

  B. In GGSCI, on the source system, issue the command: ADDPUMP group name, TRAILSOURCEtrail name.

  C. In GGSCI, on the source system, issue the command: ADDPUMP group name, EXTTRAILSOURCEtrail

  name.

  D. In GGSCI, on the source system, issue the command: ADD EXTRACT group name, EXTTRAILSOURCE trail name.

  Correct Answer: D

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GIINF/giinf_add_processes.htm#GIINF304

• Question 13:

  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 ( )

  Correct Answer: A

• Question 14:

  Which replication topology requires conflict resolution?

  A. Broadcast

  B. Consolidation

  C. Master-to-Master

  D. Cascading

  Correct Answer: A

• Question 15:

  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.

  Correct Answer: D

  Reference: https://docs.oracle.com/goldengate/c1221/gg-winux/GIORA/GUID-CFE66D1B-A010-44A794FB-0CC70CEBB8D1.htm#GIORA505 (C.3.4)

• Question 16:

  Which option is not included as part of a Veridata installation?

  A. Veridata BackPlane Server

  B. Veridata Agent

  C. Veridata Web Server

  D. Veridata Repository

  Correct Answer: A

  Reference: https://docs.oracle.com/goldengate/v12212/gg-veridata/GVDIS/GVDIS.pdf

• Question 17:

  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.

  Correct Answer: A

• Question 18:

  With BATCHSQLenabled, what causes a Replicat to use normal mode operation?

  A. statements with rows between 8k and 24k in length

  B. when BATCHSQLand GROUPTRANSOPScoexist

  C. statements which cause errors

  D. when server memory < 8GB

  Correct Answer: B

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWURF/ gg_parameters011.htm#GWURF404

• Question 19:

  How can you tell if GoldenGate has been configured for batch processing?

  A. The SPECIALRUNparameter is in the Replicat parameter file.

  B. Replicat is started with the INITIALLOADtask.

  C. There is a dedicated GoldenGate process called SPECIALRUN.

  D. The SPECIALRUNparameter is in the GLOBALS parameter file.

  Correct Answer: B

• Question 20:

  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.

  Correct Answer: C

  Reference: https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/ conflict_resolution.htm#GWUAD316