本文主要是介绍OCP-1Z0-053-V13.02-450题,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
450.Which of the following are valid program types for a lightweight job? (Choose all that apply.)
A. PLSQL_BLOCK
B. EXECUTABLE
C. JAVA_STORED_PROCEDURE
D. STORED_PROCEDURE
E. EXTERNAL
Answer: AD
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/server.112/e25494/schedover.htm#ADMIN12357
Programs
A program object (program) describes what is to be run by the Scheduler. A program includes:
-
An action: For example, the name of a stored procedure, the name of an executable found in the operating system file system (an "external executable"), or the text of a PL/SQL anonymous block.
-
A type:
STORED_PROCEDURE
,PLSQL_BLOCK
, orEXTERNAL
, whereEXTERNAL
indicates an external executable. -
Number of arguments: The number of arguments that the stored procedure or external executable accepts.
A program is a separate entity from a job. A job runs at a certain time or because a certain event occurred, and invokes a certain program. You can create jobs that point to existing program objects, which means that different jobs can use the same program and run the program at different times and with different settings. With the right privileges, different users can use the same program without having to redefine it. Therefore, you can create program libraries, where users can select from a list of existing programs.
If a stored procedure or external executable referenced by the program accepts arguments, you define these arguments in a separate step after creating the program. You can optionally define a default value for each argument.
这篇关于OCP-1Z0-053-V13.02-450题的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!