单选题What is the danger associated with stopping a running job by using the STOP_JOB procedure?（）AThe job will need to be reenabled before it will execute again.BThe job may hold locks on objects referenced within it.CAll jobs within the job group will also be stopped.DThe job may leave data in an inconsistent state.EThere is no danger in using the STOP_JOB procedure.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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
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 also be stopped.D. The job may leave data in an inconsistent state.E. There is no danger in using the STOP_JOB procedure.
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
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.
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.
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 also be stopped.D、The job may leave data in an inconsistent state.E、There is no danger in using the STOP_JOB procedure.
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
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
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.
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
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.
Which two statements are true about a job chain？（）A、 A job chain can contain a nested chain of jobsB、 The jobs in a job chain cannot have more than one dependencyC、 A job of the CHAIN type can be run using event-based or time-based schedulesD、 The jobs in a job chain can be executed only by using the events generated by the Scheduler
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
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
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
单选题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.
单选题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？（）ACreate 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.BCreate 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.CCreate 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.DCreate 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
单选题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.
单选题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?（）ASpecify the break order on the gemp group Property palette. BSpecify a break order on the dept_name and job columns property palettes. CClick and drag the dept_name and jobs column out and above of the gemp group to create a new parent group. DChange the position of the dept_name and the job columns within the gemp group.
单选题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（）AThe statistics collection continues until all objects are processed.BThe job is terminated and the statistics collected are restored to a time before the job started.CThis produces an error and the statistics collected are locked until the next time that the maintenancewindow is opened.DThe job is terminated and the statistics for the remaining objects are collected the next time that themaintenance window is opened
单选题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?（）ACreate both jobs by using events raised by the schedulerBCreate both jobs by using events raised by the applicationCCreate 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 schedulerDCreate 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
单选题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.
单选题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.
多选题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?（）AIncreasing the priority of the job class to which the job belongsBIncreasing the job's relative priority within the Job class to which it belongsCIncreasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowDMoving the job to an existing higher priority scheduler window with the same schedule and durationEIncreasing the value of the JOB_QUEUE_PROCESSES parameterFIncreasing the priority of the scheduler window to which the job belongs
单选题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 Scheduller and then create another job to perform bulk load by using events raised by the application