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;
正确答案
答案解析
相似试题
(单选题)
Which statement is true while creating subplans using Resource Manager?()
(单选题)
You want to create a temporary table while executing a procedure in a form. Which statement is true?()
(单选题)
While creating a database using Database Configuration Assistant tool, you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used?()
(单选题)
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?()
(单选题)
While designing your database, you have created the EMPLOYEEStable as an index-organized (IOT). You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()
(单选题)
You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing?()
(单选题)
While designing your database, you have created the EMPLOYEES table as an index-organized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()
(单选题)
While designing your database, you have created the EMPLOYEES table as an index/x7forganized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()
(单选题)
You are developing a tax report for the payroll application. You created a before parameter form report trigger to create three temporary tables to store text that are need while the report is executed. Which report trigger would you use to delete these temporary tables?()