Free Download Latest 2014 Pass4sure&Lead2pass Oracle 1Z0-481 Practice Tests

Vendor: Oracle
Exam Code: 1Z0-481
Exam Name: Oracle GoldenGate 11g Certified Implementation Exam Essentials

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

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

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

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

A.    TRANLOGOPTIONS ASMBUFSIZ
B.    DBOPTIONS ASMBUFSIZE
C.    TRANLOGOPTIONS BUFSIZE
D.    DBOPTIONS BUFSIZE

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

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

A.    TRANLOGOPTIONS ASMBUFSIZE
B.    DBOPTIONS ASMBUFSIZE
C.    TRANLOGOPTIONS BUFSIZE
D.    DBOPTIONS BUFSIZE

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

QUESTION 4
What three are valid responsibilities of the OGG Manager?

A.    Cleaning up GoldenGate trails.
B.    Starting dynamic processes, such as Server Collectors, extracts, replicates.
C.    Error and lag reporting.
D.    Communicating with other GoldenGate Manager processes

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

QUESTION 5
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?

A.    Inserts will generate a primary key uniqueness violation; deletes will generate a `no matching row’ not found error; updates will continue forever.
B.    None: loop detection is on by default in Oracle.
C.    New inserts will be processed without issue; updates and deletes will generate a "row not found" error.
D.    Updates and deletes will be replicated without issue new inserts will generate a primary key uniqueness violation.

Answer: B

QUESTION 6
What three types of information are reported in discard file?

A.    The details of the discarded records
B.    The database error message
C.    The trial file sequence number
D.    Runtime statistics

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

QUESTION 7
To meet a business requirement for latency, Carlos wants to break long-running source transactions into shorter commits on the target database with the replicate parameter MAXTRANSOPS what is the most important thing Carlos should consider before using MAXTRANSOPS

A.    Will business logic be lost if transaction boundaries are changed?
B.    Will a large number of small commits perform better than a smaller number of large commits?
C.    Will redo buffer size on the target database be adequate for the commit size?
D.    Will the sequence of operations be affected by changing transaction boundaries?

Answer: D
Explanation:
In reference guide, page 238: "Limitations of useYou should have a valid business case for using MAXTRANSOPS other than simply for thepurpose of expediency. To use MAXTRANSOPS is to alter the transactional integrity that isimposed by the boundaries that are defined by the source application, even though Replicatapplies the operations in the correct order."

If you want to pass Oracle 1Z0-481 successfully, donot missing to read latest lead2pass Oracle 1Z0-481 practice exams.
If you can master all lead2pass questions you will able to pass 100% guaranteed.

http://www.lead2pass.com/1Z0-481.html