Oracle 1Z0-481 Online Practice Questions and Exam Preparation

Oracle 1Z0-481 Online Questions & Answers

• Question 41:

  What Oracle GoldenGate feature provides recoverability without loss of transactions?

  A. Checkpointing
  B. Sub-second latency
  C. Two-phase commits
  D. Transactional integrity
  A. Checkpointing

• Question 42:

  Select the commands that give statistics regarding OGG process and memory resource usage.

  A. SEND...REPORT
  B. SEND...STATS
  C. SEND...CACHEMGR
  D. INFO...SHOWSTATS
  C. SEND...CACHEMGR

• Question 43:

  Which three are types of encryption supported by OGG?

  A. Parameter file encryption
  B. Password
  C. Trial file encryption
  D. Message encryption
  A. Parameter file encryption
  B. Password
  C. Trial file encryption

• Question 44:

  Which statement best describes the record Image that an Extract process stores in the GoldenGate trail by default?

  A. The new value for updated fields; the primary key for deleted rows; the after-Image for inserts
  B. An image of the contents of the record after the insert, update or delete operation
  C. An after image for inserts and a before image for updates and deletes
  D. An after image for Inserts and updates and a before image for deletes
  D. An after image for Inserts and updates and a before image for deletes

  ---

  An after image for inserts and updates and a before image for deletes.According to these guides:1. http://docs.oracle.com/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf, page 190,GETUPDATEAFTERS/IGNOREUPDATEBEFORES are the DEFAULT values of the parameters which control whether or not the after/before images of updated records are included in the records processed by GoldenGate.2. Oracle GG Fundamentals Student Guide, Version 10.4, page 113, Extract Parameters, Extract Parameter Defaults slide... Only after-image of update

• Question 45:

  You have source table with PRODUCT-ID column and target table with PRODUCT_DESCRIPTION. On the target database is a lookup table containing product codes and corresponding description. What is good way for you to lookup the product description for each transaction?

  A. SQLEXEC ( )
  B. DBLOOKUP ( )
  C. DBLOGIN ()
  D. SQLLOOKUP ( )
  A. SQLEXEC ( )

  ---

  In reference guide, page 236, in example 1 or Example 2, when a lookup is available, SQLEXEC() is the function to use.

  Incorrect answer:

  There isn't a SQLLOOKUP() function in GoldenGate!

• Question 46:

  By default which type of operations are captured by extract?

  A. Inserts, updates, deletes, and table operations such as CREATE TABLE
  B. Inserts, compresses, and updates
  C. Inserts, updates, deletes, and table operations such as ADD COLUMN
  D. Inserts only
  E. Inserts, updates, and deletes
  E. Inserts, updates, and deletes

  ---

  Reference: http://www.labo-oracle.com/Presentation-of-Oracle-GoldenGate

• Question 47:

  What GoldenGate process is responsible for capturing changes in the source database?

  A. Manager
  B. Replicate
  C. Extract
  D. Server Collector
  C. Extract

  ---

  Reference: http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

• Question 48:

  Which statements are true for a two-node, active-active OGG replication configuration?

  -Both databases may be live and processing transactions.

  -The two databases must be homogeneous.

  -

  Low latency reduces the risk of conflicts.

  A. 1 and 2
  B. 2 and 3
  C. 1 and 3
  D. I, 2, and 3
  C. 1 and 3

  ---

  Reference: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2812197300346109

• Question 49:

  Which parameter tells Extract the tables for which to capture changes?

  A. Table
  B. LOGTABLE
  C. MAP C
  D. LOG
  A. Table

  ---

  Reference: http://jianmingli.com/wp/?p=1532

• Question 50:

  How does Replicat know the structure of the source tables when the target has a different layout?

  A. GoldenGate trail file contains the metadata of incoming data
  B. Replicat uses an ODBC connection to connect to the source system tables
  C. Parameter file contains table layouts
  D. Discard file contains table layouts
  E. Source Definitions file contains table layouts
  E. Source Definitions file contains table layouts

  ---

  Reference: http://gavinsoorma.com/2010/02/oracle-goldengate-tutorial-8-filtering-and-mapping-data/