Free Sharing Lead2pass Exam Dumps

Free Download All The Latest Cisco, Microsoft, CompTIA, Oracle, VCP, CISSP Questions And Answers

Free Download Pass4sure Oracle 1Z0-481 Exam Questions

Oracle GoldenGate 11g Certified Implementation Exam Essentials: 1Z0-481 Exam
1Z0-481 Questions & Answers
Exam Code: 1Z0-481
Exam Name: Oracle GoldenGate 11g Certified Implementation Exam Essentials
Q & A: 85 Q&As

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

…go to http://www.lead2pass.com/1z0-481.html to download the full version Q&As.

Lead2pass Testking Pass4sure Actualtests Others
$99.99 $124.99 $125.99 $189 $29.99-$49.99
Up-to-Dated
Real Questions
Error Correction
Printable PDF
Premium VCE
VCE Simulator
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back