451.Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object
or the JOB_TYPE parameter in a job object?
A. PLSQL_BLOCK
B. JAVA_STORED_PROCEDURE
C. STORED_PROCEDURE
D. EXECUTABLE
E. None of the above are invalid settings.
Answer: B
答案解析：
参考：http://docs.oracle.com/cd/E11882_01/appdev.112/e40758/d_sched.htm#ARPLS72307
program_type | This attribute specifies the type of program you are creating. If it is not specified then you get an error. There are three supported values for program_type: 'PLSQL_BLOCK' This specifies that the program is a PL/SQL block. Job or program arguments are not supported when the job or program type is PLSQL_BLOCK. In this case, the number of arguments must be 0. 'STORED_PROCEDURE' This specifies that the program is a PL/SQL or Java stored procedure, or an external C subprogram. Only procedures, not functions with return values, are supported. PL/SQL procedures with INOUT or OUT arguments are not supported. 'EXECUTABLE' This specifies that the program is external to the database. External programs imply anything that can be executed from the operating system command line. AnyData arguments are not supported with job or program type EXECUTABLE. |
