多项选择题

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；

点击查看答案&解析

上一题目录下一题

相关考题

多项选择题

What are the two advantages of RMAN Block Media Recovery （BMR） over file-level recovery？（）

A. BMR lowers the mean time to recover （MTTR）.
B. BMR supports point-in-time recovery of individual data blocks.
C. BMR enables you to use incremental backups for block recovery.
D. BMR enables recovery even when the database is not mounted or open.
E. BMR enables you to use proxy backups to perform block media recovery.
F. BMR enables increased availability of data during recovery because the data file requires a recovery can remain online.

单项选择题

Using Oracle Scheduler you have scheduled two jobs， JOB_A and 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 windows group must have been created with the WEEKEND_PLAN resource plan.

单项选择题

Users are performing a large volume of inserts and deletes on the application tables in the APPS tablespace. You observe that there are several warning alerts being generated for the APPS tablespace space usage metrics. Currently， the warning threshold for the tablespace usage metrics is set to 70%. To make the generated alerts more useful as a problem identification tool， you want to reduce the frequency of alert generation for the tablespace usage metrics for the APPS tablespace. What should you do？（）

A. Disable SQL tracing for the APPS tablespace.
B. Disable logging attributes for the APPS tablespace.
C. Modify the tablespace to be a dictionary-managed tablespace.
D. Increase the critical threshold value for the tablespace space usage metrics for the APPS tablespace.
E. Increase the warning threshold value for the tablespace space usage metric for the APPS tablespace.