单项选择题
William is creating a job class. William specifies the LOGGING_FULL setting for the LOGGING_LEVEL attribute at the time of job class creation. What is the impact of using this setting?()
A. Detailed information regarding the first run of each job in the class will be written in the job log, and every operation performed on the job class will be logged.
B. Detailed information regarding each run of only the first job in the class will be written in the job log, and every operation performed on the job class will be logged.
C. Detailed information regarding each run of each job in the class will be written in the job log, and every operation performed on the job class will be logged.
D. Detailed information regarding each run of each job in the class will be written in the job log, but operations performed on the job class will not be logged.
相关考题
-
单项选择题
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
