OCP CBT Question 614

Please solve the following question.

You have a stored procedure `archive_data(p_table_name IN VARCHAR2, p_retention_days IN NUMBER)` that you want to execute daily using Oracle Scheduler. You need to create a job that calls this procedure to archive data from `SALES_LOGS` table with a retention of 90 days. Which sequence of `DBMS_SCHEDULER` calls correctly defines this job with its arguments?

Stored Procedure Signature`sqlPROCEDURE archive_data(p_table_name IN VARCHAR2, p_retention_days IN NUMBER) ISBEGIN -- Archiving logic goes here NULL;END;`

sqlDBMS_SCHEDULER.CREATE_JOB(job_name => 'ARCHIVE_SALES_JOB',job_type => 'STORED_PROCEDURE',job_action => 'archive_data(''SALES_LOGS'', 90)',repeat_interval => 'FREQ=DAILY',enabled => TRUE);

sqlDBMS_SCHEDULER.CREATE_JOB(job_name => 'ARCHIVE_SALES_JOB',job_type => 'STORED_PROCEDURE',job_action => 'archive_data',repeat_interval => 'FREQ=DAILY',enabled => TRUE);DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE('ARCHIVE_SALES_JOB', 1, 'SALES_LOGS');DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE('ARCHIVE_SALES_JOB', 2, 90);

sqlDBMS_SCHEDULER.CREATE_PROGRAM(program_name => 'ARCHIVE_PROGRAM',program_action => 'archive_data',program_type => 'STORED_PROCEDURE');DBMS_SCHEDULER.DEFINE_PROGRAM_ARGUMENT('ARCHIVE_PROGRAM', 1, 'VARCHAR2', 'IN');DBMS_SCHEDULER.DEFINE_PROGRAM_ARGUMENT('ARCHIVE_PROGRAM', 2, 'NUMBER', 'IN');DBMS_SCHEDULER.CREATE_JOB(job_name => 'ARCHIVE_SALES_JOB',program_name => 'ARCHIVE_PROGRAM',repeat_interval => 'FREQ=DAILY',enabled => TRUE);DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE('ARCHIVE_SALES_JOB', 1, 'SALES_LOGS');DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE('ARCHIVE_SALES_JOB', 2, 90);

sqlDBMS_SCHEDULER.CREATE_JOB(job_name => 'ARCHIVE_SALES_JOB',job_type => 'PLSQL_BLOCK',job_action => 'BEGIN archive_data(''SALES_LOGS'', 90); END;',repeat_interval => 'FREQ=DAILY',enabled => TRUE);

Stored Procedure SignaturesqlPROCEDURE archive_data(p_table_name IN VARCHAR2, p_retention_days IN NUMBER) ISBEGIN -- Archiving logic goes here NULL;END;

Stored Procedure Signature`sqlPROCEDURE archive_data(p_table_name IN VARCHAR2, p_retention_days IN NUMBER) ISBEGIN -- Archiving logic goes here NULL;END;`