OCP CBT Question 607

Please solve the following question.

You need to automate two distinct tasks: one involves executing a simple DML statement, and the other requires calling an existing stored procedure. You want to utilize Oracle Scheduler for both. Which two statements are true regarding the `JOB_TYPE` parameter for these scenarios?

Scenario 1: Simple DML task`sqlBEGIN DELETE FROM temp_log WHERE log_date < TRUNC(SYSDATE); END;`## Scenario 2: Stored Procedure Call`sqlPROCEDURE cleanup_old_data (p_retention_days IN NUMBER) ISBEGIN DELETE FROM archived_data WHERE archive_date < SYSDATE - p_retention_days;END;`

For Scenario 1, JOB_TYPE => 'PLSQL_BLOCK' is appropriate, and for Scenario 2, JOB_TYPE => 'STORED_PROCEDURE' is always required.

For Scenario 1, JOB_TYPE => 'PLSQL_BLOCK' is appropriate. For Scenario 2, JOB_TYPE => 'PLSQL_BLOCK' can also be used by wrapping the procedure call.

The JOB_TYPE for Scenario 1 should be SQL_STATEMENT for optimal performance.

For Scenario 2, JOB_TYPE => 'STORED_PROCEDURE' is only valid if the procedure has no arguments.

Scenario 1: Simple DML tasksqlBEGIN DELETE FROM temp_log WHERE log_date < TRUNC(SYSDATE); END;## Scenario 2: Stored Procedure CallsqlPROCEDURE cleanup_old_data (p_retention_days IN NUMBER) ISBEGIN DELETE FROM archived_data WHERE archive_date < SYSDATE - p_retention_days;END;

Scenario 1: Simple DML task`sqlBEGIN DELETE FROM temp_log WHERE log_date < TRUNC(SYSDATE); END;`## Scenario 2: Stored Procedure Call`sqlPROCEDURE cleanup_old_data (p_retention_days IN NUMBER) ISBEGIN DELETE FROM archived_data WHERE archive_date < SYSDATE - p_retention_days;END;`