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 schedu

题目

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.A: What's your job? B: My job is an accountant.()

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

4.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 creationB. The job is automatically dropped after the end dateC. The job executes with the privileges of the user SYSD.

参考答案和解析
正确答案:E
更多“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 schedu”相关问题

  • 第1题：

    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

  • 第2题：

    You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.

    You want the package to execute automatically each evening at 8:00 P.M. What should you do?

    A．Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.

    B．Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.

    C．Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account

    D．Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.


    正确答案：A
    解析：Explanation: Transfers can be defined and stored in a DTS package, which can then be run from a command line using the dtsrun utility (DTSRUN.EXE). CmdExec job steps are operating system commands or executable programs ending with .bat, .cmd, .com, or .exe. In this scenario we create a job consisting of a single cmdexec job step which runs the DTS package using the dtsrun utility.

    Incorrect answers:
    B: Only one job, not two, has to be created at the OLTP database server.

    C: If the Task Scheduler is running as the local system account it wouldn’t be able to access the remote OLAP database server.

    D: The DTS export package should be run at the OLTP database server, not at the OLAP database server. The DTS package is exported from the OLTP server to the OLAP server.

  • 第3题：

    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

  • 第4题：

    Which of the following Scheduler elements encourage object reuse？（）

    • A、 Schedule objects
    • B、 Program arguments
    • C、 Job classes
    • D、 Job arguments
    • E、 All of the above

    正确答案:A,B,D

  • 第5题：

    You have created a job class， CUST_JOB_1， with two jobs， CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true？ （）

    • A、 The member jobs would get dropped when the job class is dropped.
    • B、 Both the jobs would be executed concurrently.
    • C、 The member jobs would get disabled when the job class is dropped.
    • D、 The attributes defined at the class level would be applied to both the jobs.
    • E、 Jobs in the job class must have been assigned the same priority.

    正确答案:C,D

  • 第6题：

    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

  • 第7题：

    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

  • 第8题：

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

  • 第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.


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

  • 第10题：

    单选题
    Which of the following tasks is not performed by the job coordinator?（）
    A

    Update job log when a job completes

    B

    Spawn and remove job slaves

    C

    Write/read job info to/from memory cache

    D

    Query job table

    E

    Pass job information to job slaves


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

  • 第11题：

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

  • 第12题：

    填空题
    What job did she get at a supermarket?A job as a ____.

    正确答案： saleswoman
    解析：
    根据提示信息“一个……的工作”可推知，所缺内容应是职业类型，由对话中的职业名称可知她是一个销售人员。

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    Which of the following tasks is not performed by the job coordinator?（）

    • A、Update job log when a job completes
    • B、Spawn and remove job slaves
    • C、Write/read job info to/from memory cache
    • D、Query job table
    • E、Pass job information to job slaves

    正确答案:A

  • 第18题：

    William is creating a job class. William specifies the LOGGING_FULL setting for the LOGGING_LEVEL attribute at the time of job class creation. What is the impact of using this setting？（）  

    • A、 Detailed information regarding the first run of each job in the class will be written in the job log， and every operation performed on the job class will be logged.
    • B、 Detailed information regarding each run of only the first job in the class will be written in the job log， and every operation performed on the job class will be logged.
    • C、 Detailed information regarding each run of each job in the class will be written in the job log， and every operation  performed on the job class will be logged.
    • D、 Detailed information regarding each run of each job in the class will be written in the job log， but operations performed on the job class will not be logged.

    正确答案:C

  • 第19题：

    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

  • 第20题：

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

  • 第21题：

    单选题
    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’）；


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

  • 第22题：

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


    正确答案： 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
    解析： 暂无解析

相关内容