单选题What is the danger associated with stopping a running job by using the STOP_JOB procedure?（）A The job will need to be reenabled before it will execute again.B The job may hold locks on objects referenced within it.C All jobs within the job group will a

题目
单选题
What is the danger associated with stopping a running job by using the STOP_JOB procedure?（）
A

The job will need to be reenabled before it will execute again.

B

The job may hold locks on objects referenced within it.

C

All jobs within the job group will also be stopped.

D

The job may leave data in an inconsistent state.

E

There is no danger in using the STOP_JOB procedure.

相似考题

1.You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.How would you create these jobs?（）A. Create both jobs by using events raised by the schedulerB. Create both jobs by using events raised by the applicationC. Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the schedulerD. Create a job to rebuild indexes by using events arised by the Scheduler and then create another job to perform bulk load by using events raised by the application

2.What is the danger associated with stopping a running job by using the STOP_JOB procedure?()A. The job will need to be reenabled before it will execute again.B. The job may hold locks on objects referenced within it.C.All jobs within the job group will also be stopped.D. The job may leave data in an inconsistent state.E. There is no danger in using the STOP_JOB procedure.

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.When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?()A. The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUEB. The job will only be disabled if the value of the AUTO_DROP attribute is FALSEC. The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSED. All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUEE. The STATE column of the job table will be set to COMPLETED for the job

更多“单选题What is the danger associated with stopping a running job by using the STOP_JOB procedure?（）A The job will need to be reenabled before it will execute again.B The job may hold locks on objects referenced within it.C All jobs within the job group will a”相关问题

  • 第1题：

    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.

    正确答案:A

  • 第2题：

    You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）

    • A、Create both jobs by using events raised by the scheduler
    • B、Create both jobs by using events raised by the application
    • C、Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
    • D、Create a job to rebuild indexes by using events arised by the Scheduler and then create another job to perform bulk load by using events raised by the application

    正确答案:D

  • 第3题：

    When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?（）

    • A、The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE
    • B、The job will only be disabled if the value of the AUTO_DROP attribute is FALSE
    • C、The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE
    • D、All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE
    • E、The STATE column of the job table will be set to COMPLETED for the job

    正确答案:A,B,E

  • 第4题：

    If a job references a schedule that has been disabled， what will be the result？（）  

    • A、 The job will be automatically disabled.
    • B、 The job will never execute.
    • C、 The job will attempt to execute but will fail.
    • D、 The job will inherit the DEFAULT_SCHEDULE schedule.
    • E、 A schedule object cannot be disabled.

    正确答案:E

  • 第5题：

    Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）

    • A、Specify the break order on the gemp group Property palette. 
    • B、Specify a break order on the dept_name and job columns property palettes. 
    • C、Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 
    • D、Change the position of the dept_name and the job columns within the gemp group.

    正确答案:C

  • 第6题：

    The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects.  Which statement is true in this scenario（）

    • A、The statistics collection continues until all objects are processed.
    • B、The job is terminated and the statistics collected are restored to a time before the job started.
    • C、This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.
    • D、The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened

    正确答案:D

  • 第7题：

    You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do？（）

    • A、Create a job schedule that runs every Sunday.Assign weekly tasks to this schedule.Create a second schedule that runs on the first day of every month. Assign monthly tasks to this schedule.
    • B、Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of the week. If the day is either a Sunday or the first day of the month， execute the code.
    • C、Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or the first day of the month， execute the jobs.
    • D、Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on the first of the month

    正确答案:A

  • 第8题：

    单选题
    You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way that uses the least amount of administrative effort. What should you do？（）
    A

    Create a job schedule that runs every Sunday.Assign weekly tasks to this schedule.Create a second schedule that runs on the first day of every month. Assign monthly tasks to this schedule.

    B

    Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of the week. If the day is either a Sunday or the first day of the month， execute the code.

    C

    Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or the first day of the month， execute the jobs.

    D

    Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on the first of the month


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

  • 第9题：

    单选题
    Using the report wizard you create a tabular report to display all the columns in the EMP table. The records are ordered by the deptname and job columns. You need to create a hierarchical report that breaks on the deptname and job values. Using the data model how would you create this break structure?（）
    A

    Specify the break order on the gemp group Property palette. 

    B

    Specify a break order on the dept_name and job columns property palettes. 

    C

    Click and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. 

    D

    Change the position of the dept_name and the job columns within the gemp group.


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

  • 第10题：

    单选题
    You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?（）
    A

    Create both jobs by using events raised by the scheduler

    B

    Create both jobs by using events raised by the application

    C

    Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler

    D

    Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application


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

  • 第11题：

    单选题
    What is the danger associated with stopping a running job by using the STOP_JOB procedure？（）
    A

     The job will need to be reenabled before it will execute again.

    B

     The job may hold locks on objects referenced within it.

    C

     All jobs within the job group will also be stopped.

    D

     The job may leave data in an inconsistent state.

    E

     There is no danger in using the STOP_JOB procedure.


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

  • 第12题：

    单选题
    You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.  The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.  How would you create these jobs？（）
    A

     Create both jobs by using events raised by the scheduler

    B

     Create both jobs by using events raised by the application

    C

     Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler

    D

     Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application


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

  • 第13题：

    Using the Tivoli Dynamic Workload Console， what are two ways to  change the priority of a job？（）

    • A、 Open the "Set Priority" panel from the job properties.
    • B、 Change the priority of the job stream that contains the job.
    • C、 Select the corresponding action from the Monitor jobs task panel.
    • D、 Open the job stream properties and drill down to the job priority  panel.
    • E、 The priority of a job can only be changed from the Workload  Designer.

    正确答案:A,C

  • 第14题：

    What is the danger associated with stopping a running job by using the STOP_JOB procedure?（）

    • A、The job will need to be reenabled before it will execute again.
    • B、The job may hold locks on objects referenced within it.
    • C、All jobs within the job group will also be stopped.
    • D、The job may leave data in an inconsistent state.
    • E、There is no danger in using the STOP_JOB procedure.

    正确答案:D

  • 第15题：

    Which two statements are true about a job chain?（）

    • A、A job chain can contain a nested chain of jobs.
    • B、The jobs in a job chain cannot have more than one dependency.
    • C、A job of the CHAIN type can be run using event-based or time-based schedules.
    • D、The jobs in a job chain can be executed only by using the events generated by the Scheduler

    正确答案:A,C

  • 第16题：

    Which two statements are true about a job chain? （）(Choose two.)

    • A、A job chain can contain a nested chain of jobs.
    • B、The jobs in a job chain cannot have more than one dependency.
    • C、A job of the CHAIN type can be run using event-based or time-based schedules.
    • D、The jobs in a job chain can be executed only by using the events generated by the Scheduler

    正确答案:A,C

  • 第17题：

    Which two statements are true about a job chain？（）

    • A、 A job chain can contain a nested chain of jobs
    • B、 The jobs in a job chain cannot have more than one dependency
    • C、 A job of the CHAIN type can be run using event-based or time-based schedules
    • D、 The jobs in a job chain can be executed only by using the events generated by the Scheduler

    正确答案:A,C

  • 第18题：

    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

  • 第19题：

    单选题
    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.


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

  • 第20题：

    单选题
    You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month.  You need to schedule the jobs in the way that uses the least amount of administrative effort.  What should you do? （）
    A

     Create a job schedule that runs every Sunday. Assign weekly tasks to this schedule. Create a second schedule that runs on the first day of every month. Assign monthly tasks to this schedule. 

    B

     Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of the week. If the day is either a Sunday or the first day of the month, execute the code. 

    C

     Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or the first day of the month, execute the jobs. 

    D

     Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on the first of the month.


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

  • 第21题：

    单选题
    The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in yourdatabase instance. At a certain point of time， the maintenance window closes before the statistics are gatheredfor all objects.  Which statement is true in this scenario（）
    A

    The statistics collection continues until all objects are processed.

    B

    The job is terminated and the statistics collected are restored to a time before the job started.

    C

    This produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.

    D

    The job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened


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

  • 第22题：

    单选题
    If a job references a schedule that has been disabled， what will be the result？（）
    A

     The job will be automatically disabled.

    B

     The job will never execute.

    C

     The job will attempt to execute but will fail.

    D

     The job will inherit the DEFAULT_SCHEDULE schedule.

    E

     A schedule object cannot be disabled.


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

  • 第23题：

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

相关内容