1z0-481 | Update Oracle 1z0-481 examcollection

Q11. 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, deletes, and table operations such as ADD COLUMN

D. Inserts only

E. Inserts, updates, and deletes

Answer: E

Explanation:

Reference:

http://www.labo-oracle.com/Presentation-of-Oracle-GoldenGate

Q12. Which process (es) maintain a checkpoint file?

A. Extract only

B. Replicat only

C. Both Extract and Replicat

D. Server collector

Answer: C

Explanation:

Reference:

http://dbmentors.blogspot.com/2010/12/oracle-goldengate-tutorial-part-1.html

Q13. Which parameter could you use to start an Extract when Manager starts?

A. START

B. BEGIN

C. AUTOSTART

D. PROCESS

Answer: C

Explanation:

Reference:

http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

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

A. PASSTHRU

B. SOURCEISFILE

C. CHECKMINUTES

D. SOURCEISTABLE

E. SPECIALRUN

Answer: E

Explanation:

http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

Q15. Which OGG process (es) can change data in database?

A. Replicat only

B. Extract only

C. Extract and Replicat

D. Extract, Replicat and Manager

Answer: C

Explanation: 

Reference :

http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

Q16. Which parameter tells Extract the tables for which to capture changes?

A. Table

B. LOGTABLE

C. MAP C

D. LOG

Answer: A

Explanation:

Reference:

http://jianmingli.com/wp/?p=1532

Q17. You have discovered that an OGG checkpoint table has become corrupted. What is you best strategy to recover From this?

A. Use the CONVCHK utility on the target to restore the checkpoint table from checkpoint files.

B. Restore the target DB from backup, reposition the Extract to a point prior to the corruption, Turn to HANDLECOLLISIONS in the Replicat.

C. Use NODECHECKPONT to cause Replicat to use the checkpoint files as backup and regenerate the checkpoint table.

D. Use the GENCHK utility on the source to restore the checkpoint table from checkpoint files.

Answer: A

Explanation:

Reference:

http://www.outofboundstechnology.com/files/oracle/oraclegg_part3_trouble.pdf

Q18. When would you use the PASSTHRU parameter?

A. When using a data pump to distribute all of the trail data "as is" to a remote system.

B. When Extract is processing database transaction logs where you have a remote database connection.

C. For a SPECIALRUN one-time processing task that is doing an initial load.

D. When Extract is processing database transaction logs and writing to a local trial that will be read by a local Replicat.

Answer: A

Explanation:

Reference:

http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_wux_ref_v104.pdf

Q19. Where are GoldenGate macros defined?

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

B. Macros are defined in the GLOBALS parameter file

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

D. Macros are declared, compiled and referenced via Golden Gate’s user exits.

Answer: A

Explanation:

Reference: http://download.oracle.com/docs/cd/E15881_01/doc.104/gg_nsk_admin_v10.pdf

Q20. Which statements are true for a two-node, active-active OGG replication configuration?

Both databases may be live and processing transactions.

The two databases must be homogeneous.

Low latency reduces the risk of conflicts.

A. 1 and 2

B. 2 and 3

C. 1 and 3

D. I, 2, and 3

Answer: C

Explanation:

Reference:

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:2812197300 346109609