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: 11

You have configured and added the extract and Replicate tasks using the direct load method what do you need to do to get the processes up and running?

  1. Start the Extract task.

  2. Start the Extract task and then start the Replicat task.

  3. Start the Extract task; wait for it to stop and than start the Replicate task.

  4. Start the Replicate task

Answer: A Explanation:

In reference guide, page 279, quot;Use the RMTTASK parameter for an initial-load Extract to initiate a Replicat processing task during a GoldenGate direct load or a direct bulk load to SQL*Loader. RMTTASK directs Extract to communicate directly with Replicat over TCP/IP and bypasses the use of aCollector process or disk storage. RMTTASK also directs Extract to request that Managerstart Replicat automatically, and then stop Replicat when the run is finished. quot;

Question No: 12

You are configuring replication between two Oracle tables with the same number of columns, column table names, and data types, but in different orders. For replication purpose can you treat these as identical tables?

  1. No

  2. Yes, if the source and target Oracle versions and character sets are the same.

  3. Yes

  4. Yes, as long as the source table has a primary key define

Answer: A Explanation:

In reference guide, page 119, when replicating from identical sources to targets, the param ASSUMETARGETDEFS must be used, and the only with being with columns in different orders, the answer is NO

Question No: 13

What us expected behavior of CHEKPARMS parameter?

  1. The process checks the parameter syntax and then starts running.

  2. The process checks the parameter syntax and then stops.

  3. A report file is created listing all missing parameters.

  4. A report file is created listing all default values not specified in the parameter file.

Answer: B Explanation:

In reference guide, page 131, and I quote quot;Without processing data, GoldenGate audits the syntax and connects to the database to verify that listed tables exist. If there is a syntax failure, the process abends with GoldenGate error 190. If the syntax succeeds, the process stops and writes a message to the report file that the parameters processed successfully.quot;

Question No: 14

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

  1. DDLGEN

  2. GGSExec

  3. User Exits

  4. User Tokens

Answer: C Explanation: Reference :

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

Question No: 15

How do you control the size of the buffer that contains data extracted from an ASM instance?

  1. TRANLOGOPTIONS ASMBUFSIZ

  2. DBOPTIONS ASMBUFSIZE

  3. TRANLOGOPTIONS BUFSIZE

  4. DBOPTIONS BUFSIZE

Answer: A Explanation: Reference :

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

Question No: 16

How do you control the size of the buffer that contains data extracted from?

  1. TRANLOGOPTIONS ASMBUFSIZE

  2. DBOPTIONS ASMBUFSIZE

  3. TRANLOGOPTIONS BUFSIZE

  4. DBOPTIONS BUFSIZE

Answer: C Explanation: Reference :

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

Question No: 17

What three are valid responsibilities of the OGG Manager?

  1. Cleaning up GoldenGate trails.

  2. Starting dynamic processes, such as Server Collectors, extracts, replicates.

  3. Error and lag reporting.

  4. Communicating with other GoldenGate Manager processes

Answer: A,B,C Reference:

http://gavinsoorma.com/2010/02/goldengate-tutorial-3-configuring-the-manager-process/ http://space.itpub.net/10248702/viewspace-624577

Question No: 18

You have implemented multi-master Oracle/Oracle replication without a provision to exclude transactions committed by a Replicat process. What errors are likely to occur?

  1. Inserts will generate a primary key uniqueness violation; deletes will generate a ‘no matching row’ not found error; updates will continue forever.

  2. None: loop detection is on by default in Oracle.

  3. New inserts will be processed without issue; updates and deletes will generate a “row not found” error.

  4. Updates and deletes will be replicated without issue new inserts will generate a primary key uniqueness violation.

Answer: B

Question No: 19

What three types of information are reported in discard file?

  1. The details of the discarded records

  2. The database error message

  3. The trial file sequence number

  4. Runtime statistics

Answer: A,B,C Reference:

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

Question No: 20

Which command forces a running Extract to close the current trial and start writing to the next trial sequence number?

  1. ALTER EXTTRAIL lt;trail namegt;, NEXTSEQNO

  2. ALTER EXTTRAIL lt;trail namegt;, ROLLOVER

  3. SEND EXTRACT lt;groupgt;, ETROLLOVER

  4. SEND EXTRACT lt;groupgt;, ROLLOVER

Answer: D Explanation:

In reference guide, page 36:Syntax SEND EXTRACT lt;group namegt;, {CACHEMGR

{CACHESTATS | CACHEQUEUES | CACHEPOOL} |FORCESTOP |FORCETRANS lt;IDgt; [THREAD lt;ngt;] [FORCE] |GETLAG |GETTCPSTATS |LOGEND |REPORT |ROLLOVER

|SHOWTRANS [lt;IDgt;] [THREAD lt;ngt;] [COUNT lt;ngt;][DURATION lt;durationgt;lt;unitgt;] [TABULAR][FILE lt;namegt; [DETAIL]] |SKIPTRANS lt;IDgt; [THREAD lt;ngt;] [FORCE]STATUS

|STOP |TLTRACE {DEBUG | OFF | lt;levelgt;} [DDLINCLUDE | DDL[ONLY]] [FILE] lt;file namegt; |TRACE[2] lt;tracefilegt; |TRACE[2] OFF |TRACEINIT |TRANLOGOPTIONS

{PURGEORPHANEDTRANSACTIONS | NOPURGEORPHANEDTRANSACTIONS}

|TRANLOGOPTIONS TRANSCLEANUPFREQUENCY lt;minutesgt; |VAMMESSAGE

“lt;Teradata commandgt;” |VAMMESSAGE {“ARSTATS” | “INCLUDELIST [filter]” | “EXCLUDELIST [filter]”} |VAMMESSAGE “OPENTRANS”}

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.