搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【多选题】

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

查看正确答案
更多“Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? （）”相关的问题
第1题
[单选题] You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）  

A、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；  B、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；  C、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；  D、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；  

点击查看答案
第2题
[] Which DBMS_SCHEDULER procedures can be used to enable a program?（）

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

点击查看答案
第3题
[] Which DBMS_SCHEDULER procedures can be used to enable a program？（）

A、A. ENABLE  B、B. ENABLE_PROGRAM  C、C. VALIDATE_PROGRAM  D、D. SET_ATTRIBUTE  E、E. SET_ENABLED  

点击查看答案
第4题
[单选题] You are creating a job class. You have issued the following command to create the job class：  SQL> BEGIN   DBMS_SCHEDULER.CREATE_JOB_CLASS（        JOB_CLASS_NAME => ’LOW_PRIORITY_CLASS’，        RESOURCE_CONSUMER_GROUP => ’LOW_GROUP’，        LOGGING_LEVEL => DBMS_SCHEDULER.LOGGING_FULL，        LOG_HISTORY => 1200，   COMMENTS => ’LOW JOB PRIORITY CLASS’）；        END；        SQL> /   What will be the result of the above command？（）

A、 The command will be executed successfully.  B、 The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.  C、 The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.  D、 The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.  E、 The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the  DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.  

点击查看答案
第5题
[] 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？（） 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、A.GRANT dba TO dbmgr;  B、B.GRANT connect TO dbmgr;  C、C.GRANT resource TO dbmgr;  D、D.GRANT hs_admin_role TO dbmgr;  E、E.GRANT manage scheduler TO dbmgr;  

点击查看答案
第6题
[] Which DBMS_SCHEDULER procedure（s） can be used to alter an existing job？（）

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

点击查看答案
第7题
[多选题] 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；  

点击查看答案
第8题
[单选题] 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  

点击查看答案
第9题
[单选题] 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.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服