多选题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 re

第1题：

第2题：

第3题：

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.

第4题：

You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）

• A、the XML script
• B、the PL/SQL script
• C、the DBMS_SCHEDULER package
• D、Enterprise Manager to schedule the backup

第5题：

Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control？（）

• A、the port used by the listener
• B、the protocol used by the listener
• C、the server name where the listener runs
• D、the log file and trace file destination for the listener
• E、the database services to be registered with the listener

第6题：

You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?（）

• A、Increasing the priority of the job class to which the job belongs
• B、Increasing the job's relative priority within the Job class to which it belongs
• C、Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
• D、Moving the job to an existing higher priority scheduler window with the same schedule and duration
• E、Increasing the value of the JOB_QUEUE_PROCESSES parameter
• F、Increasing the priority of the scheduler window to which the job belongs

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

第14题：

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.

第15题：

Which DBMS_SCHEDULER procedure（s） can be used to alter an existing job？（）

• A、 SET_ATTRIBUTE_NULL
• B、 ALTER_JOB
• C、 ALTER_JOB_PARAMETERS
• D、 ALTER
• E、 SET_ATTRIBUTE

第16题：

Which DBMS_SCHEDULER procedures can be used to enable a program?（）

• A、ENABLE启用
• B、ENABLE_PROGRAM
• C、VALIDATE_PROGRAM
• D、SET_ATTRIBUTE设置属性
• E、SET_ENABLED

第17题：

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.

第18题：

What are four capabilities of the mysql client program?（）

• A、Creating, dropping, and modifying tables and indexes
• B、Initiating a binary backup of the database by using the START BACKUP command
• C、Displaying replication status information
• D、Shutting down the server by using the SHUTDOWN command
• E、Creating and dropping databases
• F、Creating and administering users

第19题：

第20题：

第21题：

第22题：

第23题：