oracle 1z0-447 practice test

Question 1

Which three describe a valid OGG Event Action?
A. Stop the process
B. Write a checkpoint before and/or after writing the record to the trail.
C. Run a shell command
D. Purge old trail files

Question 2

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.

Question 3

What is the default format for a GoldenGate trail?

• A. ASCII:ASCII format
• B. INPUT ASCII: from 1to 127 representing ASCII characters
• C. SQL: SQL statements
• D. CDF: Canonical Data format
• E. XML: XML statement

Question 4

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

• A. PASSTHRU
• B. SOURCEISFILE
• C. CHECKMINUTES
• D. SOURCEISTABLE
• E. SPECIALRUN

Question 5

What file must be configured in order to use custom encryption keys?

• A. ENCKEYS
• B. ENCRYPT
• C. GLOBALS
• D. CUSTKEYS

Question 6

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, and then resume array fetches afterwards.
• B. The Extract will revert to single-row fetch mode for all tables.
• C. The Extract will abend unless LOBMEMORY is increased.
• D. The Extract will perform poorly due to paging unless LOBMEMORY is increased.

Question 7

What Oracle GoldenGate feature provides recoverability without loss of transactions?

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

Question 8

Which three types of information are stored in the GoldenGate trial header?

• A. Before or after image indicator
• B. Data type (e.g. integer, alphanumeric)
• C. Relative byte address of the commit record
• D. Time of the transaction

Question 9

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.

Question 10

Ideally which process should be configured purge old trial files?

• A. Manager
• B. Extract
• C. Replicat
• D. Pump