News

  1. Home
  2. All posts
All posts, Golden Gate, Oracle by Team Ajara

Quiz Questions for Oracle GoldenGate

Quiz Questions for Oracle GoldenGate.

 

1.Which statements are true about Oracle GoldenGate? (Select more than one.)

  • Oracle Golden Gate is an Oracle Database product that supports other Oracle products.
  • Oracle Golden Gate is a middleware product that does not require an Oracle database.
  • Oracle GoldenGate captures changes from the Oracle Redo logs or non-Oracle transaction logs and moves them to another database.
  • Oracle Golden Gate can support high availability.

 

2.Oracle Golden Gate is middleware software for business intelligence, and it is designed to support a heterogeneous database environment.

  • True
  • False

 

3.Which statements are true?

  • The Extract process can capture committed changes from the transaction logs and write them to a trail file.
  • The Data Pump process can capture committed changes from the transaction logs and write them to a trail file.
  • The Data Pump process can move data from a local trail file to a remote trail file.
  • The Replicat process can move changes from a local trail file to the database.

 

4.What products make up the Oracle Golden Gate product line? (Select all that apply.)

  • Oracle Golden Gate Veridata
  • Management Pack for Oracle GoldenGate
  • Oracle Golden Gate Application Adapters (that is, Flat File and Java adapters)

 

5.Which of the following statements is true?

  • Oracle Golden Gate checkpoints are stored in an Oracle control file.
  • The CKPT background process records the Oracle Golden Gate checkpoint.
  • The Oracle Golden Gate checkpoint supports Oracle GoldenGate recovery.
  • There is likely to be only one Oracle Golden Gate checkpoint file.

 

6.ADD TRANDATA enables supplemental logging of key values in the transaction logs whenever a row change occurs.

  • True
  • False

 

7.Both the extract and replicat users require the DBA role for the database.

  • True
  • False

 

8.SQLEXEC can communicate only via a SQL query.

  • True
  • False

 

9.What is required if you are configuring column mapping or transformation on the target system? (Select one.)

  • Source-definitions file
  • Target-definitions file
  • Both a source-definitions file and a target-definitions file 
  • Neither, because transformations never occur on the target

 

10.User _______ are a set of variables.

  • Macros
  • Tokens
  • Exits
  • Procedures

 

11.User exits can be used for tables being processed by a data pump Extract in pass-through mode.

  • True
  • False

 

12.Key names and values can be stored in:

  • GLOBALS
  • ENCKEYS
  • SOURCEDEFS
  • DEFSFILE

 

13.Only the ENCRYPTTRAIL extract parameter should be set to encrypt and decrypt the records in the trail file.

  • True
  • False

 

14.Oracle GoldenGate supports bidirectional synchronization only for homogeneous environments.

  • True
  • False

See Also: