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 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

相似考题

1.To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?()A. LOG_HISTORYB. JOB_LOG_RETENTIONC. WINDOW_LOG_RETENTIOND. WHICH_LOGE. LOG_NAME

2.When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?()A. SET_JOB_ARGUMENT_VALUEB. SET_JOB_VALUE_ANYDATAC. SET_JOB_ANYDATA_VALUED. SET_SPECIAL_JOB_VALUEE. SET_JOB_ANYTYPE_VALUE

3.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

4.Which DBMS_SCHEDULER procedures can be used to enable a program?()A. ENABLE启用B. ENABLE_PROGRAMC. VALIDATE_PROGRAMD. SET_ATTRIBUTE设置属性E. SET_ENABLED

更多“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”相关问题

  • 第1题：

    It's said that he's looking for a new job, one_________ he can get more free time.

    A．when
    B．where
    C．that
    D．which

    答案：B
    解析：
    考查定语从句。one是a newjob的同位语，同时one是先行词，后面是个定语从句，由于定语从句he can get more free time不缺少任何成分，说明空格处在从句中作状语，需要用where引导，意为“从新工作中获得更多的自由时间”。如果选which的话，应该是one(a job)from which he can get more free time，故选B。

  • 第2题：

    What is the use of work assets on safety plans？ （）

    • A、 The work asset determines to which assets and locations a safety plan can be applied.
    • B、 Only safety plans with associated work assets can be used in combination with job plans.  
    • C、 The safety plan can only be applied to work orders with the same asset or location associated.
    • D、 The work assets combined with the work on a job plan dictate which safety information is required.

    正确答案:D

  • 第3题：

    Which three are true?（）

    • A、A MERGE statement is used to merge the data of one table with data from another.
    • B、A MERGE statement replaces the data of one table with that of another.
    • C、A MERGE statement can be used to insert new rows into a table.
    • D、A MERGE statement can be used to update existing rows in a table.

    正确答案:A,C,D

  • 第4题：

    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

  • 第5题：

    You want to be notified when the space usage of an existing critical tablespace has reached 75% of the allocated space. Which option would you use to achieve this？（）

    • A、run a procedure to check the tablespace space usage
    • B、define the warning threshold for the tablespace at 75% in Database Control
    • C、create a trigger to be executed when tablespace space usage reaches 75%
    • D、submit a job by using DBMS_JOB package to check the free space in the tablespace at regular intervals
    • E、define the warning threshold to be 75% for the tablespace by ALTER TABLESPACE .. ADD THRESHOLD command

    正确答案:B

  • 第6题：

    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

  • 第7题：

    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

  • 第8题：

    单选题
    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？（）
    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


    正确答案： E
    解析： 暂无解析

  • 第9题：

    多选题
    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,C
    解析： 暂无解析

  • 第10题：

    问答题
    Psychological techniques used to lessen the effort involved in a given job include a detailed study of the motion required to do the job, the equipment used, and the conditions under which the job is performed.

    正确答案：
    解析：

  • 第11题：

    多选题
    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


    正确答案： C,D
    解析： 暂无解析

  • 第12题：

    单选题
    Which procedure(s) shall be used to determine risk of collision? （）
    A

    Watching the compass bearing of an approaching vessel

    B

    Systematic observation of objects detected by radar

    C

    Long-range radar scanning

    D

    All of the above


    正确答案： A
    解析： 暂无解析

  • 第13题：

    Which statement is true about the SDM QoS wizard and its ability to enable a QoS policy on router interfaces？（）

    • A、QoS can be enabled on interfaces used for Easy VPN clients
    • B、QoS can be enabled on IPsec VPN interfaces and tunnels
    • C、QoS can be enabled on interfaces with an existing QoS policy
    • D、the QoS policy can be enabled for incoming and outgoing traffic on the interface

    正确答案:B

  • 第14题：

    Which command is used to open the database after an incomplete recovery？（）

    • A、 alter database open
    • B、 alter database open repairlog
    • C、 alter database open resetlogs
    • D、 alter database open resetlog
    • E、 alter database resetlogs open

    正确答案:C

  • 第15题：

    Which statements describe the capabilities of the DBMS_NETWORK_ACL_ADMIN package?（）

    • A、It can be used to allow the access privilege settings for users but not roles.
    • B、It can be used to allow the access privilege settings for users as well as roles.
    • C、It can be used to control the time interval for which the access privilege is available to a user.
    • D、It can be used to selectively restrict the access for each user in a database to different host computers.
    • E、It can be used to selectively restrict a user's access to different applications in a specific host computer.

    正确答案:B,C,D

  • 第16题：

    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

  • 第17题：

    To set the history retention period for either window logging or job logging individually， which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used？（）

    • A、 LOG_HISTORY
    • B、 JOB_LOG_RETENTION
    • C、 WINDOW_LOG_RETENTION
    • D、 WHICH_LOG
    • E、 LOG_NAME

    正确答案:A,D

  • 第18题：

    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.

    正确答案:E

  • 第19题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed.  What should you do？ （）

    • A、You should create a job which is assigned to the Database Maintenance category
    • B、You should create an Alert which will run another to delete the maintenance job.
    • C、You should create a job. You schedule the job to run only once.
    • D、You should create a job. The job uses the Automatically delete job option

    正确答案:D

  • 第20题：

    多选题
    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


    正确答案： B,A
    解析： 暂无解析

  • 第21题：

    多选题
    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


    正确答案： D,A
    解析： 暂无解析

  • 第22题：

    多选题
    Which three are true? （）
    A

    A MERGE statement is used to merge the data of one table with data from another.

    B

    A MERGE statement replaces the data of one table with that of another.

    C

    A MERGE statement can be used to insert new rows into a table.

    D

    A MERGE statement can be used to update existing rows in a table.


    正确答案： D,B
    解析： 暂无解析

  • 第23题：

    多选题
    To set the history retention period for either window logging or job logging individually， which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used？（）
    A

    LOG_HISTORY

    B

    JOB_LOG_RETENTION

    C

    WINDOW_LOG_RETENTION

    D

    WHICH_LOG

    E

    LOG_NAME


    正确答案： D,C
    解析： 暂无解析

相关内容