Latesttests
2018 Jan Oracle Official New Released 1z0-481
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-481.html

Oracle GoldenGate 11g Certified Implementation Exam Essentials

Question No: 41

Which utility is responsible for generating source data definitions files?

  1. EMSCLNT

  2. COBGEN

  3. DDLGEN

  4. DEFGEN

Answer: D Reference:

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

Question No: 42

Which statement correctly describes GoldenGate Extract and Replicat process reports?

  1. By default process reports are named for the Extract or Replicat group and up to 99 old reports can be saved depending on the REPORTUM parameter.

  2. By default process reports are named for the Extract or Replicat group and up to 10 old reports are kept.

  3. Process reports take the name set by the optional report parameter of the ADD extract replicat command and up to 99 old reports can be saved depending on the REPORTNUM parameter.

  4. Process reports take the name set by the required report file parameters and up to 10 old reports will be saved.

Answer: D

Question No: 43

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.

  1. 1 and 2

  2. 2 and 3

  3. 1 and 3

  4. I, 2, and 3 Answer: C

Reference:

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

Question No: 44

What is GGSCI an acronym for?

  1. GoldenGate secure command interface

  2. GoldenGate software command interface

  3. GoldenGate software connection interface

  4. GoldenGate secure connection interface

Answer: B Reference:

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

Question No: 45

You have a requirement to extract changes from an oracle 10g database without installing or running any GoldenGate processes on the host server. To accomplish this, which GoldenGate process parameter is most likely to be part of your solution?

  1. TRANLOGOPTIONS ARCHIVEDLOGONLY

  2. WILDCARDRESOLVE DYNAMIC

  3. This configuration is not supported in GoldenGate 10.

  4. ASSUMETARGETDEFS

Answer: A Reference:

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

Question No: 46

Where is user token data stored?

  1. Trail file

  2. Parameter file

  3. Discord file

  4. Report file

Answer: A Reference:

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

Question No: 47

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

  1. Alter lt;groupgt;, extseqno 10, extrba 100345

  2. Alter Replicat *, exttrail lt;trail prefixgt;, extseqno 10, extrba 100345

  3. Alter Replicat lt;groupgt;, sequence lO, rba 100345

  4. Alter lt;groupgt;, sequence 10, rba 100345

Answer: A Reference:

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

Question No: 48

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?

  1. The first unique key alpha-numerically, excluding virtual columns and nullable columns, will be treated as the primary key.

  2. This configuration is not supported by GoldenGate; Replicat will abend on updates or deletes.

  3. The first column, excluding virtual columns and nullable columns, will be treated as the pr key.

  4. 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

Question No: 49

Which best describes the function of OGG user tokens?

  1. User-defined variables

  2. Security tokens

  3. User privileges

  4. User-defined functions

Answer: A

Question No: 50

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

  1. @STRCAT ()

  2. @STEXT ()

  3. @strext () and @ strcat ()

  4. @STRFIND ( )

Answer: C Reference:

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

100% Free Download!
Download Free Demo:1z0-481 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-481 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 Latesttests IT Certification PDF and VCE

Comments are closed.