OCP CBT Question 616

Please solve the following question.

A DBA is creating a `PROGRAM` for a job named `DAILY_STAT_GATHER` using `DBMS_SCHEDULER.CREATE_PROGRAM`. The program will execute the `DBMS_STATS.GATHER_SCHEMA_STATS` procedure. The DBA wants to define two arguments: `OWNNAME` (schema name, VARCHAR2) and `OPTIONS` (statistics options, VARCHAR2, with a default value of 'GATHER AUTO'). Which `DBMS_SCHEDULER` procedures, in the correct order, should be used to define this program and its arguments?

Desired Program Action`sqlDBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'SCOTT',options => 'GATHER AUTO');`

sqlDBMS_SCHEDULER.CREATE_PROGRAM (...);DBMS_SCHEDULER.DEFINE_PROGRAM_ARGUMENT (...);DBMS_SCHEDULER.SET_PROGRAM_ARGUMENT_DEFAULT_VALUE (...);

sqlDBMS_SCHEDULER.CREATE_PROGRAM (...);DBMS_SCHEDULER.SET_PROGRAM_ARGUMENT_DEFAULT_VALUE (...);DBMS_SCHEDULER.DEFINE_PROGRAM_ARGUMENT (...);

sqlDBMS_SCHEDULER.CREATE_PROGRAM (...);DBMS_SCHEDULER.SET_JOB_ARGUMENT_VALUE (...);

sqlDBMS_SCHEDULER.CREATE_PROGRAM (...);DBMS_SCHEDULER.DEFINE_PROGRAM_ARGUMENT (...);DBMS_SCHEDULER.ENABLE (...);

Desired Program ActionsqlDBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'SCOTT',options => 'GATHER AUTO');

Desired Program Action`sqlDBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'SCOTT',options => 'GATHER AUTO');`