单选题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
单选题
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
参考解析
解析：
暂无解析
相关考题：
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.
Youwanttopurgejobentriesolderthan5daysfromthejoblog.Youdonotwanttopurgewindowlogentries.Whichcommandwillyouusetoaccomplishthistask?() A.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=5，job_name=’JOB1’）；B.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=5，job_name=’JOB_LOG’）；C.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=5，which_log=’JOB1’）；D.EXECUTEDBMS_SCHEDULER.PURGE_LOG（log_history=5，which_log=’JOB_LOG’）；
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
列出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.
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’）；
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.
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
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
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 want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG
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
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command： SQL SELECT job FROM emp 2 WHERE job=’CLERK’ FOR UPDATE OF empno; SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）A、LOCK TABLE emp IN SHARE MODE;B、LOCK TABLE emp IN EXCLUSIVE MODE;C、DELETE FROM emp WHERE job=’MANAGER’;D、INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;E、SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
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.
列出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?（）ASET_JOB_ARGUMENT_VALUEBSET_JOB_VALUE_ANYDATACSET_JOB_ANYDATA_VALUEDSET_SPECIAL_JOB_VALUEESET_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
单选题You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A DBA_SCHEDULER_JOB_RUN_DETAILSB DBA_SCHEDULER_RUNNING_JOBSC DBA_SCHEDULER_JOBSD DBA_SCHEDULER_JOB_LOG
单选题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’）；
单选题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
单选题Which of the following tasks is not performed by the job coordinator?（）AUpdate job log when a job completesBSpawn and remove job slavesCWrite/read job info to/from memory cacheDQuery job tableEPass 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.
多选题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）的员工人数（）Aselect job from emp;Bselect job,count(*) from emp;Cselect distinct job,count(*) from emp;Dselect job,count(*) from emp group by job;Eselect job,sum(empno) from emp group by job;