单项选择题
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？（）
A.DBA_SCHEDULER_RUNNING_JOBS
B.DBA_SCHEDULER_JOB_RUN_DETAILS
C.DBA_SCHEDULER_JOBS
D.DBA_SCHEDULER_JOB_LOG -
单项选择题
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？（）
A. 45.5
B. 65
C. 70
D. 100 -
单项选择题
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？（）
A. You must assign users to consumer groups.
B. You must grant the switch privilege to the users.
C. You must create a resource plan directive.
D. You must specify the complex resource plan.
