Oracle GoldenGate 11g Certified Implementation Exam Essentials

Question 1

What Oracle GoldenGate feature provides recoverability without loss of transactions?

A. Transactional integrity

B. Checkpointing

C. Two-phase commits

D. Sub-second latency

Correct Answer: B

Question 2

What is the GoldenGate command line interface?

A. GGSCI

B. GGCTRL

C. GGCUI

D. SQLCUI

Correct Answer: A

Question 3

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 Actualtests4sure members. You can sign-up / login (it's free).

Question 4

You want encrypt message sent or over TCP/IP to server usserver1, where the goldenGate manage process is running on port 7809. Your requirements include using a custom encryption key and advanced encryption standard (AES), and you have created an ENCKEYS file
What parameters should you use?

A. RMTHOST usserval, MGRPORT AES, ENCRYPTKEY MYKWY, MBRPORT 7809

B. RMTHOST usserval, MGRPORT 7809, ENCRYPT BLOWFISH ENCRYPTKEY MYKEY

C. This feature is not supported in oracle goldenGate 10.

D. RMTHOST usserval, MGRPORT 7809, ENCRYPT AES, ENCRYPT KEY

Correct Answer: B

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

Question 5

Where are GoldenGate macros defined?

A. Macros are placed in a file and referenced using an environment variable.

B. Macros are declared, compiled and referenced via Golden Gate's user exits.

C. Macros can be defined in the parameter file or included in a macro file

D. Macros are defined in the GLOBALS parameter file

Correct Answer: C

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

Question 6

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?

A. No

B. Yes, as long as the source table has a primary key define

C. Yes

D. Yes, if the source and target Oracle versions and character sets are the same.

Correct Answer: A

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

Question 7

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

C. Examples 1 and 2

D. Example 3 only

Correct Answer: D

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

Question 8

By default which type of operations are captured by extract?

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

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

C. Inserts only

D. Inserts, compresses, and updates

E. Inserts, updates, and deletes

Correct Answer: E

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

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

Latest Update

Useful Links

Contact Us