单选题While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）AOracle Scheduler would write detailed information to the job log for each run of each job in the job cla

题目

单选题

While creating a job class using the DBMS_SCHEDULER package， you set the logging level to LOGGING_RUNS. What would be the impact of this setting？（）

Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.

Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.

Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.

Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.

参考答案和解析

正确答案： A

解析：暂无解析

更多“While creating a job class using the DBMS_SCHEDULER package，”相关问题

第1题

下列有关类声明的代码片段，哪一项是正确的？（） A、 import java.sql.*； package school； class Student{ }B、 package school； import java.sql.*； class Student{ }C、 package school； class Student{ } import java.sql.*；D、 package school； import java.sql.*；private String name； class Student{ }

点击查看答案
第2题

Which DBMS_SCHEDULER procedure（s） can be used to alter an existing job？（）A、 SET_ATTRIBUTE_NULLB、 ALTER_JOBC、 ALTER_JOB_PARAMETERSD、 ALTERE、 SET_ATTRIBUTE

点击查看答案
第3题

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.

点击查看答案
第4题

You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）A、 LOGGING_OFFB、 LOGGING_RUNSC、 LOGGING_FULLD、 LOGGING_NULL

点击查看答案
第5题

Your business has departmental reports that are generated every day. Each department must use the same set of queries， but access a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed； currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）A、 By having each user run the report generation procedure at the scheduled time， supplying the necessary input variables.B、 By creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOB.C、 By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.D、 By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.E、 By creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER.

点击查看答案
第6题

单选题Your business has departmental reports that are generated every day. Each department must use the same set of queries， but accesses a different subset of data in the tables， depending on which department generates the report. The format of the reports is being developed; currently， the format changes daily. How would you configure the database to ensure that each department generates its report （based on its target data） using the most recent report format every day？（）A by having each user run the report generation procedure at the scheduled time， supplying the necessary input variablesB by creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOBC by having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the reportD by having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the reportE by creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER

点击查看答案
第7题

多选题While creating a scheduler window using the DBMS_SCHEDULER package， a user logged in as DBMGR gets the error message insufficient privileges. Which two commands would you use to resolve this error？（）AGRANT dba TO dbmgr;BGRANT connect TO dbmgr;CGRANT resource TO dbmgr;DGRANT hs_admin_role TO dbmgr;EGRANT manage scheduler TO dbmgr;

点击查看答案

While creating a job class using the DBMS_SCHEDULER package，

题目

参考答案和解析

更多“While creating a job class using the DBMS_SCHEDULER package，”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容