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

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

The job may hold locks on objects referenced within it.

All jobs within the job group will also be stopped.

The job may leave data in an inconsistent state.

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题

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

点击查看答案
第3题

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.

点击查看答案
第4题

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

点击查看答案
第5题

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.

点击查看答案
第6题

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.

点击查看答案
第7题

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

点击查看答案

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

第2题

第3题

第4题

第5题

第6题

第7题

相关内容