1Z0-447 Free Practice Test

Which Logdump command is used to check how many change records are in the trail file?

1. A. STATS
2. B. REPORT
3. C. REPORTCOUNT
4. D. COUNT

Correct Answer: D

For which database, other than SQL Server, does an Extract use a method of Secondary Truncation Point management?

1. A. Teradata
2. B. Informix
3. C. Sybase
4. D. DB2

Correct Answer: D

You must replicate to JMS Queues. Which product in the Oracle GoldenGate portfolio should be used?

1. A. Oracle Goldengate for Big Data
2. B. Oracle Goldengate Application Adapters
3. C. Oracle Goldengate Veridata
4. D. Oracle Data Integrator Adapters

Correct Answer: B

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?

1. A. The Extract will revert to single-row fetch mode, and then resume array fetches afterwards.
2. B. The Extract will revert to single-row fetch mode for all tables.
3. C. The Extract will abend unless LOBMEMORY is increased.
4. D. The Extract will perform poorly due to paging unless LOBMEMORY is increased.

Correct Answer: A

How should you configure Replicat to control how errors are handled in one-way replication?

1. A. UseREPERRORin the Replicat parameter file.
2. B. UseHANDLECOLLISIONin the Replicat parameter file.
3. C. Use Conflict Detection and Resolution in the Replicat parameter file.
4. D. UseMAPEXCEPTIONin the Replicat parameter file.

Correct Answer: A