You are creating a job class. You have issued the following command to create the job class: SQL> BEGIN DBMS_SCHEDULER.CREATE_JOB_CLASS( JOB_CLASS_NAME => ’LOW_PRIORITY_CLASS’, RESOURCE_CONSUMER_GROUP => ’LOW_GROUP’, LOGGING_LEVEL => DBMS_SCHEDULER.LOGGING_FULL, LOG_HISTORY => 1200, COMMENTS => ’LOW JOB PRIORITY CLASS’); END; SQL> / What will be the result of the above command?()
A.
The command will be executed successfully.
B.
The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
C.
The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
D.
The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
E.
The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.