Oracle Global Human Resources Cloud Implementation Specialist — Question 27

Replicat makes checkpoints in the trail file to mark its last read position. Select two ways to create checkpoint tables.

Answer options

• A. Run the chkpt_db_extracttrail.sql script.
• B. Run the chkpt_db_create.sql script.
• C. Use the ADD Extract Trail command.
• D. Use the INFO REPLICAT command with the SHOWCH option.
• E. Use the ADD CHECKPOINTTABLE command.

Correct answer: B, E

Explanation

The correct answers are B and E because running the chkpt_db_create.sql script specifically creates the checkpoint tables, while the ADD CHECKPOINTTABLE command is also designed for creating checkpoint tables. The other options either do not create checkpoint tables or serve different purposes within the Replicat process.