Oracle GoldenGate 10 Essentials v6.4 (1z0-539)

Page:    1 / 5   
Total 72 questions

Where is user token data stored?

  • A. Trail file
  • B. Parameter file
  • C. Discord file
  • D. Report file


Answer : A

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

What command is issued to alter Replicat to start processing trail number 10 at relative byte address 100345?

  • A. Alter <group>, extseqno 10, extrba 100345
  • B. Alter Replicat *, exttrail <trail prefix>, extseqno 10, extrba 100345
  • C. Alter Replicat <group>, sequence lO, rba 100345
  • D. Alter <group>, sequence 10, rba 100345


Answer : A

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

Neither your source, nor your target table has a primary key, and you have not designated KEYCOLS. How will the Replicat proceed to identify matching target rows to update or delete?

  • A. The first unique key alpha-numerically, excluding virtual columns and nullable columns, will be treated as the primary key.
  • B. This configuration is not supported by GoldenGate; Replicat will abend on updates or deletes.
  • C. The first column, excluding virtual columns and nullable columns, will be treated as the pr key.
  • D. The combination of all fields up to the first thirty-two will be treated as a compound primary key


Answer : A

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

Which best describes the function of OGG user tokens?

  • A. User-defined variables
  • B. Security tokens
  • C. User privileges
  • D. User-defined functions


Answer : A

What could you use to formal 123456789 to format of social security number 123-456-789?

  • A. @STRCAT ()
  • B. @STEXT ()
  • C. @strext () and @ strcat ()
  • D. @STRFIND ( )


Answer : C

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

Replicat is responsible for which three options?

  • A. Reading data out of the GoldenGate trails.
  • B. Performing data flow filtering.
  • C. Performing data transformations.
  • D. Check pointing the oldest uncommitted transaction.


Answer : A,B,C

What GoldenGate process writes to RMTTRAILS?

  • A. Server/Collector
  • B. Extract
  • C. Pump
  • D. Replicat
  • E. All of the above


Answer : B

Reference:
http://hi.baidu.com/nich4/blog/item/19a3e81cad1ff7bb4bedbc50.html

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


Answer : E

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

What is the default threshold for message compression in OGG?

  • A. 1000
  • B. 100
  • C. O
  • D. By default, messages are not compressed.


Answer : A

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

What is the name and the location of the file that lists the key values used by extract for encryptions and Server Collector for decryption?

  • A. KEYGEN file in the GoldenGate data location
  • B. COBGEN file in the GoldenGate installation location
  • C. GGSKEY file in the GoldenGate data location
  • D. GGSKEY file in the GoldenGate installation location
  • E. ENCKEYS file in the GoldenGate installation location


Answer : E

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

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


Answer : E

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

Which three are types of encryption supported by OGG?

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


Answer : A,B,C

Which three are required to correctly configure an OGG?

  • A. A maximum file size
  • B. An extract process
  • C. A trail file identifier
  • D. Designation as local or remote


Answer : B,C,D

Reference:
http://www.biblogs.com/2010/03/22/configuring-odi-10136-to-use-oracle-golden-gate-for- changed-data-capture/ http://www.pythian.com/news/7959/oracle-goldengate-installation-part-1/

What process is the recommended method to purge old GoldenGate trials?

  • A. Extract r
  • B. Replicat
  • C. Manager
  • D. Manager and Replica


Answer : C

Reference:
http://forums.oracle.com/forums/thread.jspa?messageID=9297810

Which statement correctly explains when you would use ASSUMETARGETDEFS?

  • A. The target tables are already created.
  • B. Only the fields in the target tables are mapped.
  • C. The source and target tables have identical data structure.
  • D. You have specified wildcards in either the TABLE or MAP parameters


Answer : C

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

Page:    1 / 5   
Total 72 questions