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

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

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

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

第2题:

The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command? ()(Choose two.)

A. The job is enabled by default after creation

B. The job is automatically dropped after the end date

C. The job executes with the privileges of the user SYS

D. The globalization environment that exists at the time of the job creation prevails at the job runs


参考答案:B, C

第3题:

A: What's your job? B: My job is an accountant.()


参考答案: 错误

第4题:

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

第5题:

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’);

正确答案:D

第6题:

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

第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题:

The user SYS creates a job by using the following command:Which two statements are true about the job that was created by the preceding command?()

A. The job is enabled by default after creation

B. The job is automatically dropped after the end date

C. The job executes with the privileges of the user SYS

D.


参考答案:B, C

第9题:

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

第10题:

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

更多相关问题