1z0-481 | All About Best Quality 1z0-481 practice test
Q31. 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:
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_troubleshooting_v104.pdf
Q32. Which three types of information are stored in the GoldenGate trial header?
A. Before or after image indicator
B. Data type (e.g. integer, alphanumeric)
C. Relative byte address of the commit record
D. Time of the transaction
Answer: ABC
Explanation:
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
Q33. Which could be used to map a value stored in a user token to a target column?
A. @GETENV
B. GGHEADER
C. GGENVIRONMENT
D. ©TOKEN
Answer: D
Explanation:
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
Q34. 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:
Reference :
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
Q35. When GoldenGate is configured for Archived Only Mode (ALO), what must be considered configuring the middle-tier server for Capture?
A. The middle-tier capture server has the same endian order and bit width
B. The middle-tier server must have a database installed on it
C. GoldenGate only supports Windows or Linux on the middle-tier server
D. GoldenGate only supports UNIX on the middle-tier server
Answer: B
Q36. Which statement correctly explains when you would use ASSUMETARGETDEFS?
A. The target tables are already created.
B. Only the fields in the target tables are mapped.
C. The source and target tables have identical data structure.
D. You have specified wildcards in either the TABLE or MAP parameters
Answer: C
Explanation:
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
Q37. What us expected behavior of CHEKPARMS parameter?
A. The process checks the parameter syntax and then starts running.
B. The process checks the parameter syntax and then stops.
C. A report file is created listing all missing parameters.
D. 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 "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."
Q38. 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?
A. The first unique key alpha-numerically, excluding virtual columns and nullable columns, will be treated as the primary key.
B. This configuration is not supported by GoldenGate; Replicat will abend on updates or deletes.
C. The first column, excluding virtual columns and nullable columns, will be treated as the pr key.
D. The combination of all fields up to the first thirty-two will be treated as a compound primary key
Answer: A
Explanation:
Reference: http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_syb_inst_v104.pdf
Q39. 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:
Reference :
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf
Q40. 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?
A. TRANLOGOPTIONS ARCHIVEDLOGONLY
B. WILDCARDRESOLVE DYNAMIC
C. This configuration is not supported in GoldenGate 10.
D. ASSUMETARGETDEFS
Answer: A
Explanation:
Reference:
http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf