多选题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 resource TO dbmgr;DGRANT hs_admin_role TO dbmgr;EGRANT manage scheduler TO dbmgr;
多选题
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 dbmgr;
E
GRANT manage scheduler TO dbmgr;
参考解析
解析：
暂无解析
相关考题：
Using the situation stated in the Special window, the schedule performance index (SPI) for WBS Element P is:A . 1.1B . 0.9C . 0.956D . 1.15E . 0.869
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 . PB . QC . RD . SE . T
104 Using the situation stated in the Special window, the schedule performance index (SPI) for WBS Element P is:A. 1.10B. 0.90C. 0.956D. 1.15E. 0.869
Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? () A. SET_ATTRIBUTE_NULLB. ALTER_JOBC. ALTER_JOB_PARAMETERSD. ALTERE. SET_ATTRIBUTE
Which DBMS_SCHEDULER procedures can be used to enable a program?() A. ENABLE启用B. ENABLE_PROGRAMC. VALIDATE_PROGRAMD. SET_ATTRIBUTE设置属性E. SET_ENABLED
What are four capabilities of the mysql client program?() A.Creating, dropping, and modifying tables and indexesB.Initiating a binary backup of the database by using the START BACKUP commandC.Displaying replication status informationD.Shutting down the server by using the SHUTDOWN commandE.Creating and dropping databasesF.Creating and administering users
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 belongsB. Increasing the job‘s relative priority within the Job class to which it belongsC. Increasing the resource allocation for the consumer group mapped to the scheduler job‘s job class within the plan mapped to the scheduler windowD. Moving the job to an existing higher priority scheduler window with the same schedule and durationE. Increasing the value of the JOB_QUEUE_PROCESSES parameterF. Increasing the priority of the scheduler window to which the job belongs
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.
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.
Which DBMS_SCHEDULER procedure（s） can be used to alter an existing job？（）A、 SET_ATTRIBUTE_NULLB、 ALTER_JOBC、 ALTER_JOB_PARAMETERSD、 ALTERE、 SET_ATTRIBUTE
You want to configure and schedule offline database backups to run automatically. Which tool or utilitywould you use to achieve this（）A、the XML scriptB、the PL/SQL scriptC、the DBMS_SCHEDULER packageD、Enterprise Manager to schedule the backup
Which DBMS_SCHEDULER procedures can be used to enable a program?（）A、ENABLE启用B、ENABLE_PROGRAMC、VALIDATE_PROGRAMD、SET_ATTRIBUTE设置属性E、SET_ENABLED
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 listenerB、the protocol used by the listenerC、the server name where the listener runsD、the log file and trace file destination for the listenerE、the database services to be registered with the listener
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.
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 belongsB、Increasing the job's relative priority within the Job class to which it belongsC、Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowD、Moving the job to an existing higher priority scheduler window with the same schedule and durationE、Increasing the value of the JOB_QUEUE_PROCESSES parameterF、Increasing the priority of the scheduler window to which the job belongs
What are four capabilities of the mysql client program?（）A、Creating, dropping, and modifying tables and indexesB、Initiating a binary backup of the database by using the START BACKUP commandC、Displaying replication status informationD、Shutting down the server by using the SHUTDOWN commandE、Creating and dropping databasesF、Creating and administering users
单选题Your business has departmental reports that are generated every day. Each department must use the same set of queries， but accesses 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？（）Aby having each user run the report generation procedure at the scheduled time， supplying the necessary input variablesBby creating a program using DBMS_JOB that accepts one or more variables， and creating a job that calls this program using DBMS_JOBCby having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the reportDby having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the reportEby creating a program using DBMS_SCHEDULER that accepts one or more variables， and creating a job that calls this program using DBMS_SCHEDULER
多选题Which DBMS_SCHEDULER procedures can be used to enable a program？（）AENABLEBENABLE_PROGRAMCVALIDATE_PROGRAMDSET_ATTRIBUTEESET_ENABLED
多选题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 resource TO dbmgr；DGRANT hs_admin_role TO dmbgr；EGRANT manage scheduler TO dbmgr；
单选题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.
单选题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.
多选题Which DBMS_SCHEDULER procedures can be used to enable a program?（）AENABLE启用BENABLE_PROGRAMCVALIDATE_PROGRAMDSET_ATTRIBUTE设置属性ESET_ENABLED
单选题While setting up an Oracle database for one of your critical applications， you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective？（）Aconfigure the database to run in ARCHIVELOG modeBconfigure the Flash Recovery Area to enable automatic database backupCschedule the database backup using DBMS_JOB package after creating the databaseDschedule the database backup using Recovery Manager （RMAN）commands after creating the databaseEschedule the database backup using Database Configuration Assistant （DBCA）while creating the database
多选题Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control？（）Athe port used by the listenerBthe protocol used by the listenerCthe server name where the listener runsDthe log file and trace file destination for the listenerEthe database services to be registered with the listener
单选题You want to configure and schedule offline database backups to run automatically. Which tool or utilitywould you use to achieve this（）Athe XML scriptBthe PL/SQL scriptCthe DBMS_SCHEDULER packageDEnterprise Manager to schedule the backup
多选题Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? （）ASET_ATTRIBUTE_NULLBALTER_JOBCALTER_JOB_PARAMETERSDALTERESET_ATTRIBUTE
多选题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?（）AIncreasing the priority of the job class to which the job belongsBIncreasing the job's relative priority within the Job class to which it belongsCIncreasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowDMoving the job to an existing higher priority scheduler window with the same schedule and durationEIncreasing the value of the JOB_QUEUE_PROCESSES parameterFIncreasing the priority of the scheduler window to which the job belongs