违法和不良信息举报 联系客服
免费注册 登录

While creating a scheduler window using the DBMS_SCHEDULER p

题目
多选题
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？（）
A

GRANT dba TO dbmgr；

B

GRANT connect TO dbmgr；

C

GRANT resource TO dbmgr；

D

GRANT hs_admin_role TO dmbgr；

E

GRANT manage scheduler TO dbmgr；

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

104 Using the situation stated in the Special window, the schedule performance index (SPI) for WBS Element P is:

A. 1.10

B. 0.90

C. 0.956

D. 1.15

E. 0.869


正确答案：A

第2题：

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


参考答案：A, D

第3题：

Using the situation stated in the Special window, the schedule performance index (SPI) for WBS Element P is:

A . 1.1

B . 0.9

C . 0.956

D . 1.15

E . 0.869


正确答案：A

第4题：

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.

正确答案:C

第5题：

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


参考答案：B, C

第6题：

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


参考答案：A, E

第7题：

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


参考答案：A, C, E, F

第8题：

Using the data shown in the Special window, Activities P, Q, and T are critical path activities. In order to shorten the time duration of the project, which activity should be "crashed" first?

A . P

B . Q

C . R

D . S

E . T


正确答案：A

第9题：

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.

正确答案:A

第10题：

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

正确答案:A,E

更多相关问题
相关内容