Oracle 1Z0-481 Online Practice Questions and Exam Preparation

Oracle 1Z0-481 Online Questions & Answers

• Question 51:

  Where are GoldenGate macros defined?

  A. Macros can be defined in the parameter file or included in a macro file
  B. Macros are defined in the GLOBALS parameter file
  C. Macros are placed in a file and referenced using an environment variable.
  D. Macros are declared, compiled and referenced via Golden Gate's user exits.
  A. Macros can be defined in the parameter file or included in a macro file

  ---

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

• Question 52:

  How many Extracts can write to the same GoldGate trail?

  A. Only one
  B. Up to 10
  C. Up to 50
  D. Unlimited
  A. Only one

  ---

  http://jianmingli.com/wp/?p=1534

• Question 53:

  What is the default format for a GoldenGate trail?

  A. ASCII:ASCII format
  B. INPUT ASCII: from 1to 127 representing ASCII characters
  C. SQL: SQL statements
  D. CDF: Canonical Data format
  E. XML: XML statement
  A. ASCII:ASCII format

• Question 54:

  Which three describe a valid OGG Event Action?

  A. Stop the process
  B. Write a checkpoint before and/or after writing the record to the trail.
  C. Run a shell command
  D. Purge old trail files
  A. Stop the process
  B. Write a checkpoint before and/or after writing the record to the trail.
  C. Run a shell command

  ---

  In reference guide, page 312, Syntax EVENTACTIONS ([STOP | ABORT | FORCESTOP][IGNORE [TRANSACTION [INCLUDEVENT]][DISCARD][LOG [INFO | WARNING]][REPORT][ROLLOVER][SHELL ][TRACE [TRANSACTION] [PURGE | APPEND]][CHECKPOINT [BEFORE | AFTER | BOTH]][, ...])

• Question 55:

  What GoldenGate facility allows for custom processing in response to a data value?

  A. DDLGEN
  B. GGSExec
  C. User Exits
  D. User Tokens
  C. User Exits

  ---

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

• Question 56:

  Select the function that stores environmental values.

  A. GGENVIRONMENT
  B. @COLGEN
  C. @GETENV
  D. ETOKEN
  C. @GETENV

• Question 57:

  Which three types of information are stored in the GoldenGate trial header?

  A. Before or after image indicator
  B. Data type (e.g. integer, alphanumeric)
  C. Relative byte address of the commit record
  D. Time of the transaction
  A. Before or after image indicator
  B. Data type (e.g. integer, alphanumeric)
  C. Relative byte address of the commit record

  ---

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

• Question 58:

  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
  C. The source and target tables have identical data structure.

  ---

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

• Question 59:

  What is GGSCI an acronym for?

  A. GoldenGate secure command interface
  B. GoldenGate software command interface
  C. GoldenGate software connection interface
  D. GoldenGate secure connection interface
  B. GoldenGate software command interface

  ---

  Reference: http://gavinsoorma.com/tag/ggsci/

• Question 60:

  Which best describes the function of OGG user tokens?

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