Oracle 1Z0-481 Online Practice Questions and Exam Preparation

Oracle 1Z0-481 Online Questions & Answers

• Question 11:

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

  A. Alter , extseqno 10, extrba 100345
  B. Alter Replicat *, exttrail , extseqno 10, extrba 100345
  C. Alter Replicat , sequence lO, rba 100345
  D. Alter , sequence 10, rba 100345
  A. Alter , extseqno 10, extrba 100345

  ---

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

• Question 12:

  Which parameter could you use to start an Extract when Manager starts?

  A. START B. BEGIN
  C. AUTOSTART
  D. PROCESS
  C. AUTOSTART

  ---

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

• Question 13:

  Which Manager Parameter sets will report current lag every hour and write a critical message for any Extract/Replicate with a lag over 60 minutes?

  A. LAGBEPOBTHOURS 1, LAGINFO 1 and LAGCRITICAL 60
  B. LAGREPORTMINUTES 60, LAGINFOHOURS 1
  C. LAGREPOBT 1, I.AGCRITICALHOURS 1
  D. LAGREPOBTHOURS 1, LAGINFOMINUTES 30, LAGCR JTTCAI-M I
  B. LAGREPORTMINUTES 60, LAGINFOHOURS 1

  ---

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

• Question 14:

  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
  E. ENCKEYS file in the GoldenGate installation location

  ---

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

• Question 15:

  Select the statement that is supported by OGG DDL Replication.

  A. ENCRYPT
  B. ALTGLOBAL
  C. CREATE ROLE
  D. ALTDB
  C. CREATE ROLE

• Question 16:

  Which statements are true of goldenGate password encryption?

  A password can be encrypted and pasted into a parameter file.

  An encrypted password can be generated using the default key.

  An encrypted password can be generated using a user defined-key.

  A. 1 only
  B. 2 only
  C. 3 only
  D. 1 and 3
  E. 1, 2 and 3
  E. 1, 2 and 3

  ---

  One of the encryption options that GoldenGate provides is to use Passwords in the extract and replicate parameter file. Also, the encrypted password can be generated using user defined key up to 128-bit or using the default key.

  Reference:

  http://gavinsoorma.com/2010/07/goldengate-encrypting-data-and-passwords/

• Question 17:

  How would you specify the data source for a secondary Extract functioning as a data pump?

  A. EXTTRAILSOURCE
  B. SOURCEISTABLE
  C. SOURCEISTRAIL
  D. LOCTRAILSOURC
  A. EXTTRAILSOURCE

  ---

  On page 293 of reference guide, EXTTRAILSOURCE is the parameter to specify data pump

• Question 18:

  Which Replicat parameter is used when looking up table definitions in a file?

  A. SPECIALRUN
  B. DEFERAPPLYINTERVAL
  C. SOURCEISFILE
  D. SOURCEDEFS
  D. SOURCEDEFS

• Question 19:

  Ideally which process should be configured purge old trial files?

  A. Manager
  B. Extract
  C. Replicat
  D. Pump
  A. Manager

  ---

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

• Question 20:

  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
  A. The first unique key alpha-numerically, excluding virtual columns and nullable columns, will be treated as the primary key.

  ---

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