OCP-1Z0-053-V12.02-446题

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

Answer: A

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#ARPLS72409

SET_ATTRIBUTE Procedure

This procedure modifies an attribute of a Scheduler object. It is overloaded to accept values of various types. To set an attribute to NULL, use theSET_ATTRIBUTE_NULL procedure. The attributes that can be set depend on the object being altered. All object attributes can be changed, except the object name.

Syntax

DBMS_SCHEDULER.SET_ATTRIBUTE (

   name           IN VARCHAR2,

   attribute      IN VARCHAR2,

   value          IN {BOOLEAN|DATE|TIMESTAMP|

                        TIMESTAMP WITH TIME ZONE|TIMESTAMP WITH LOCAL TIME ZONE|

                        INTERVAL DAY TO SECOND});

 

DBMS_SCHEDULER.SET_ATTRIBUTE (

   name           IN VARCHAR2,

   attribute      IN VARCHAR2,

   value          IN VARCHAR2,

   value2         IN VARCHAR2 DEFAULT NULL);

Parameters

Table 129-79 SET_ATTRIBUTE Procedure Parameters

ParameterDescription

name

The name of the object

attribute

See Table 129-81 through Table 129-91.

value

The new value being set for the attribute. This cannot be NULL. To set an attribute value to NULL, use the SET_ATTRIBUTE_NULLprocedure.

value2

The value2 argument is for an optional second value. Most attributes have only one value associated with them, but some can have two.

job_priority

This attribute specifies the priority of this job relative to other jobs in the same class as this job. If multiple jobs within a class are scheduled to be executed at the same time, the job priority determines the order in which jobs from that class are picked up for execution by the job coordinator. It can be a value from 1 through 5, with 1 being the first to be picked up for job execution.

If no job priority is specified when creating a job, the default priority of 3 is assigned to it.