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.

单项选择题

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.

相关考题

单项选择题 Whichviewwillyouusetoviewinformationregardingthejobsthatarecurrentlyrunninginadatabase？（）

单项选择题 YourecentlycreatedacomplexresourceplannamedDB_PLANthathastwosubplansnamedOLTP_PLANandDSS_PLAN.TheOLTP_PLANandDSS_PLANsubplansareallotted70percentand30percentofthetotalCPUresources，respectively.TheOLTP_PLANsubplanallocates35percentoftheavailableCPUresourcestoaresourceconsumergroupnamedACCT_CLERKS.Accordingtothe OLTP_PLANsubplan，theremaining65percentoftheavailableCPUresourcesisallocatedtoasecondresourceconsumergroupnamedMKT_CLERKS.TheCPUresourcesavailabletotheDSS_PLANsubplanaredividedintotworesourceconsumergroupsnamedMKT_MANAGERSandFIN_MANAGERS.TheMKT_MANAGERSgroupreceives65percentoftheavailableCPUresources，andtheFIN_MANAGERSgroupreceives35percentoftheavailableCPUresources.WhatpercentageofactualCPUresourceswilltheresourceconsumergroup，MKT_CLERKS，receive，iftheDSS_PLANsubplandoesNOTconsumeanyCPUresources？（）

单项选择题 You execute the following block of code： SQL>BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN （ SIMPLE_PLAN => ’DEPARTMENTS’， CONSUMER_GROUP1 => ’PAYROLLL’， GROUP1_CPU => 50， CONSUMER_GROUP2 => ’SALES’， GROUP2_CPU => 25， CONSUMER_GROUP3 => ’MARKETING’， GROUP3_CPU => 25）； END； SQL>/ What is a prerequisite for using the simple resource plan created by executing the above code？（）

1z0-043