网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for 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.
参考答案
更多 “ The job to gather optimizer statistics for objects runs as part of the automatic maintenance window inyour database instance. At a certain point of time， the maintenance window closes before the statisticsare gathered for 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、二级 VF 培训班承诺考试不合格退培训费 电话:0851-5561184 网址:www（20）设有一组作业，它们的作业提交时刻及估计运行时间如下所示：作业号 提交时刻 估计运行时间（分钟）Job1 8：30 70Job2 9：10 30Job3 9：30 15Job4 9：50 5在单道批处理方式下，采用短作业优先调度算法，作业的执行顺序为;A）Job1，Job4，Job3，Job2B）Job1，Job3，Job4，Job2C）Job4，Job3，Job2，Job1D）Job4，Job1，Job2，Job3
考题
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.
考题
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.
考题
Which of the following tasks is not performed by the job coordinator?()
A. Update job log when a job completesB. Spawn and remove job slavesC. Write/read job info to/from memory cacheD. Query job tableE. Pass job information to job slaves
考题
When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?()
A. SET_JOB_ARGUMENT_VALUEB. SET_JOB_VALUE_ANYDATAC. SET_JOB_ANYDATA_VALUED. SET_SPECIAL_JOB_VALUEE. SET_JOB_ANYTYPE_VALUE
考题
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 creationB. The job is automatically dropped after the end dateC. The job executes with the privileges of the user SYSD. The globalization environment that exists at the time of the job creation prevails at the job runs
考题
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
考题
设有一组作业，它们的作业提交时刻及估计运行时间如下所示： 作业号 提交时刻 估计运行时间(分钟) Job1 8：30 70 Job2 9：10 30 Job3 9：30 15 Job4 9：50 5 在单道批处理方式下，采用短作业优先调度算法，作业的执行顺序为A．Job1，Job4，Job3，Job2B．Job1，Job3，Job4，Job2C．Job4，Job3，Job2，Job1D．Job4，Job1，Job2，Job3
考题
列出EMP表中,从事每个工种(JOB)的员工人数()
A.select job from emp;B.select job,count(*) from emp;C.select distinct job,count(*) from emp;D.select job,count(*) from emp group by job;E.select job,sum(empno) from emp group by job;
考题
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.
考题
When setting arguments for a job， which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype？（） A、 SET_JOB_ARGUMENT_VALUEB、 SET_JOB_VALUE_ANYDATAC、 SET_JOB_ANYDATA_VALUED、 SET_SPECIAL_JOB_VALUEE、 SET_JOB_ANYTYPE_VALUE
考题
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.
考题
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.
考题
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
考题
Which of the following tasks is not performed by the job coordinator？（）A、 Update job log when a job completesB、 Spawn and remove job slavesC、 Write/read job info to/from memory cacheD、 Query job tableE、 Pass job information to job slaves
考题
列出EMP表中，从事每个工种（JOB）的员工人数（）A、select job from emp;B、select job,count(*) from emp;C、select distinct job,count(*) from emp;D、select job,count(*) from emp group by job;E、select job,sum(empno) from emp group by job;
考题
单选题When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?（）A
SET_JOB_ARGUMENT_VALUEB
SET_JOB_VALUE_ANYDATAC
SET_JOB_ANYDATA_VALUED
SET_SPECIAL_JOB_VALUEE
SET_JOB_ANYTYPE_VALUE
考题
单选题When setting arguments for a job， which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype？（）A
SET_JOB_ARGUMENT_VALUEB
SET_JOB_VALUE_ANYDATAC
SET_JOB_ANYDATA_VALUED
SET_SPECIAL_JOB_VALUEE
SET_JOB_ANYTYPE_VALUE
考题
单选题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.
考题
单选题Which of the following tasks is not performed by the job coordinator？（）A
Update job log when a job completesB
Spawn and remove job slavesC
Write/read job info to/from memory cacheD
Query job tableE
Pass job information to job slaves
考题
单选题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.
考题
单选题Consider the following code snippet： BEGIN DBMS_SCHEDULER.SET_ATTRIBUTE （ name = ，，lne_job1， attribute = ，，job_priority， value = 1）； END； / If this code were executed， which of the following statements would be true？（）A
The priority of the lne_job1 job would be set to 1.B
The lne_job1 job would be executed synchronously.C
The lne_job1 job would run immediately in the users current session.D
The lne_job1 job would retain its current priority.E
The job will immediately take priority over all running jobs.
考题
单选题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.
考题
单选题I find （）A
it difficult for them to finish the job in timeB
difficult for them to finish the job in timeC
they have much difficulty to finish the job in timeD
that difficult for them to finish the job in time
考题
单选题Which of the following tasks is not performed by the job coordinator?（）A
Update job log when a job completesB
Spawn and remove job slavesC
Write/read job info to/from memory cacheD
Query job tableE
Pass job information to job slaves
考题
多选题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
考题
单选题列出EMP表中，从事每个工种（JOB）的员工人数（）A
select job from emp;B
select job,count(*) from emp;C
select distinct job,count(*) from emp;D
select job,count(*) from emp group by job;E
select job,sum(empno) from emp group by job;
热门标签
最新试卷
