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

Question 1

Which parameters) would be used for one-time initial replicat?

A. SOURCEISTABLE

B. CHECKMINUTES

C. SPECIALRUN

D. PASSTHRU

E. SOURCEISFILE

Correct Answer: C

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

Question 2

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. Examples 1 and 2

B. Example 2 only

C. Examples 1 and 3

D. Example 3 only

Correct Answer: D

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

Question 3

By default which type of operations are captured by extract?

A. Inserts, updates, deletes, and table operations such as CREATE TABLE

B. Inserts, compresses, and updates

C. Inserts, updates, and deletes

D. Inserts, updates, deletes, and table operations such as ADD COLUMN

E. Inserts only

Correct Answer: C

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

Question 4

What three are valid responsibilities of the OGG Manager?

A. Error and lag reporting.

B. Starting dynamic processes, such as Server Collectors, extracts, replicates.

C. Cleaning up GoldenGate trails.

D. Communicating with other GoldenGate Manager processes

Correct Answer: A,B,C

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

Question 5

In addition to using the parameter comment to enter remarks in parameter file(s) can be used?

A. \\

B. //

C. -

D. /*

Correct Answer: C

Question 6

Which best describes the function of OGG user tokens?

A. Security tokens

B. User-defined variables

C. User privileges

D. User-defined functions

Correct Answer: B

Question 7

You have configured and added the extract and Replicate tasks using the direct load method what do you need to do to get the processes up and running?

A. Start the Extract task.

B. Start the Extract task and then start the Replicat task.

C. Start the Extract task; wait for it to stop and than start the Replicate task.

D. Start the Replicate task

Correct Answer: A

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

Question 8

What GoldenGate process writes to RMTTRAILS?

A. Extract

B. All of the above

C. Pump

D. Replicat

E. Server/Collector

Correct Answer: A

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

Welcome to TestSimulate

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