Exam Code: 1z0-481 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle GoldenGate 11g Certified Implementation Exam Essentials
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1z0-481 Exam.
2016 Oct 1z0-481 Study Guide Questions:
Q11. Which three are types of encryption supported by OGG?
A. Parameter file encryption
C. Trial file encryption
D. Message encryption
Q12. In order to add delete Replicat processes without specifying a checkpoint table, Gerald has edited the GLOBALS parameter file. To get the change to take effect, Gerald exits from the GGSCI command line, but GGSCI fails to restart. Which solution Is most likely to solve Gerald’s problem
A. Use a text editor to check the GLOBALS file for syntax errors and fix them
B. Use the cleanup replicat command
C. Verify that Oracle environment variables are set correctly
D. Add the Oracle GoldenGate Installation directory to the system PATH
Q13. Which Replicat parameter is used when looking up table definitions in a file?
Latest 1z0-481 exam fees:
Q14. Where are GoldenGate macros defined?
A. Macros can be defined in the parameter file or included in a macro file
B. Macros are defined in the GLOBALS parameter file
C. Macros are placed in a file and referenced using an environment variable.
D. Macros are declared, compiled and referenced via Golden Gate’s user exits.
Q15. How does Replicat know the structure of the source tables when the target has a different layout?
A. GoldenGate trail file contains the metadata of incoming data
B. Replicat uses an ODBC connection to connect to the source system tables
C. Parameter file contains table layouts
D. Discard file contains table layouts
E. Source Definitions file contains table layouts
Q16. Which GGSCI command(s) show all available information on both read and write checkpoint for an Extract?
Example: 1 INFO EXTRACT <group name> Example: 2 INFO EXTRACT <group name>, DETAIL
Example: 3 INFO EXTRACT <group name>, SHOWCH
A. Example 2 only
B. Example 3 only
C. Examples 1 and 3
D. Examples 1 and 2
Reference : http://jianmingli.com/wp/?p=1532
Approved 1z0-481 forum:
Q17. Which parameter could you use to start an Extract when Manager starts?
Q18. 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?
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."
Q19. Which three are required to correctly configure an OGG?
A. A maximum file size
B. An extract process
C. A trail file identifier
D. Designation as local or remote
Q20. 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?
B. Yes, if the source and target Oracle versions and character sets are the same.
D. Yes, as long as the source table has a primary key define
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