单选题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  L

第1题：

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？（）

• A、 Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.
• B、 Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.
• C、 Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.
• D、 Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.

第2题：

You want to limit access to a method of a public class to members of the same class. Which access modifier accomplishes this objective？（）  

• A、 Public
• B、 Private
• C、 Protected
• D、 Transient
• E、 No access modifier is required

第3题：

第4题：

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.

第5题：

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.

第6题：

You want to limit access to a method of a public class to members of the same class. Which access accomplishes this objective？（）  

• A、 public
• B、 private
• C、 protected
• D、 transient
• E、 default access

第7题：

Using Oracle Scheduler you have scheduled two jobs， JOB_Aand JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）

• A、 A window must have been created with the WEEKEND_PLAN resource plan.
• B、 A program must have been created with the WEEKEND_PLAN resource plan.
• C、 A job class must have been created with the WEEKEND_PLAN resource plan.
• D、 A window group must have been created with the WEEKEND_PLAN resource plan.

第8题：

第9题：

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_OFF
• B、 LOGGING_RUNS
• C、 LOGGING_FULL
• D、 LOGGING_NULL

第10题：

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.