1z1-481 by Oracle Actual Free Exam Q&As

Question 1

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

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

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 2

You want to configure replication of CREATE TABLE statements from oracle to Teradata, so that only new table created in your mapped source schema is Replicated. Which should be the part of solution?

A. DDL INCLUDE MAPPED in extra parameter file. B. DDL EXCLUDE MAPPED in extra parameter file. C. DDL INCLUDE UNMAPPED in extra parameter file. D. This feature is not supported in oracle goldenGate 10.

Discussion 0

Correct Answer: A Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 3

What three types of information are reported in discard file?

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

Discussion 0

Correct Answer: A,B,C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 4

Nicole is preparing initial data load Extract task EINI_HR using the parameter DBOPTIONS FECHBATCHSIZE 2000. What is likely to happen if one of her source tables includes LOB data?

A. The Extract will revert to single-row fetch mode for all tables. B. The Extract will perform poorly due to paging unless LOBMEMORY is increased. C. The Extract will revert to single-row fetch mode, and then resume array fetches afterwards. D. The Extract will abend unless LOBMEMORY is increased.

Discussion 0

Correct Answer: C Vote an answer

Question 5

By default which type of operations are captured by extract?

A. Inserts only B. Inserts, updates, deletes, and table operations such as CREATE TABLE C. Inserts, compresses, and updates D. Inserts, updates, deletes, and table operations such as ADD COLUMN E. Inserts, updates, and deletes

Discussion 0

Correct Answer: E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 6

Where is user token data stored?

A. Discord file B. Parameter file C. Trail file D. Report file

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 7

What three are valid responsibilities of the OGG Manager?

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

Discussion 0

Correct Answer: B,C,D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 8

You are responsible for replication between your central office and twelve regional nodes. What is the best product for you to use to actively monitor thirteen GoldenGate TDM instances and configure email alerts based on process status?

A. Oracle GoldenGate Transactional Data Management B. Oracle GoldenGate Director C. Oracle GoldenGate veridata D. Oracle GoldenGate Monitor

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Oracle GoldenGate 11g Certified Implementation Exam Essentials - 1z1-481 Exam Practice Test