1z1-481 by Oracle Valid Free Exam Practice Test

Question 1

What Oracle GoldenGate feature provides recoverability without loss of transactions?

A. Sub-second latency B. Transactional integrity C. Two-phase commits D. Checkpointing

Correct Answer: D

Question 2

Which statement correctly explains when you would use ASSUMETARGETDEFS?

A. The source and target tables have identical data structure. B. The target tables are already created. C. You have specified wildcards in either the TABLE or MAP parameters D. Only the fields in the target tables are mapped.

Correct Answer: A

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

Question 3

Which three are types of encryption supported by OGG?

A. Password B. Trial file encryption C. Parameter file encryption D. Message encryption

Correct Answer: A,B,C

Question 4

Which statement correctly describes GoldenGate Extract and Replicat process reports?

A. By default process reports are named for the Extract or Replicat group and up to 10 old reports are kept. B. Process reports take the name set by the required report file parameters and up to 10 old reports will be saved. C. By default process reports are named for the Extract or Replicat group and up to 99 old reports can be saved depending on the REPORTUM parameter. D. Process reports take the name set by the optional report parameter of the ADD extract replicat command and up to 99 old reports can be saved depending on the REPORTNUM parameter.

Correct Answer: B

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

Question 5

What GoldenGate process writes to RMTTRAILS?

A. Pump B. All of the above C. Extract D. Server/Collector E. Replicat

Correct Answer: C

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

Question 6

Which translations are captured if you ADD EXTRACT BEGIN now 1:00 p.m., but START EXTRACT at 2:00 p.m.?

A. Transactions started before 1:00 p.m and committed after 1:00 p.m. B. Transactions started on or after 1:00 p.m. C. Transactions started on or after 2:00 p.m. D. Transactions started before 1:00 p.m and committed after 2:00 p.m.

Correct Answer: D

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

Question 7

In GoldenGate terms, what is the definition of Extract lag?

A. The difference in time between when a change record is processed by the extract and the timestamp of the record in the data source. B. The difference in time between when a change is made to source data and when that change is reflected in the target data. C. The difference in time between when a change record is received at the target system and when the change is reflected in the target data. D. The difference in time between the current times at the target system.

Correct Answer: A

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

Question 8

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

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

Correct Answer: A

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

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