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.
Explanation:
job_type
Job action type (‘PLSQL_BLOCK’, ‘STORED_PROCEDURE’, ‘EXECUTABLE’, or ‘CHAIN’)
For program_type, B is correct as well:
https://docs.oracle.com/database/121/ARPLS/d_sched.htm#ARPLS72235
program_type
This attribute specifies the type of program you are creating. If it is not specified then you get an error. These are the 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 job is going to be run outside the database using an external executable. 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.
‘EXTERNAL_SCRIPT’
This specifies that the job is an external script that uses the command shell of the computer running the job. For Windows this is cmd.exe and for UNIX based systems the sh shell, unless a different interpreter is specified by prefixing the first line of the script with #!.
‘SQL_SCRIPT’
This specifies that the program is a SQL*Plus script.
A job using this program must point to a credential that contains a valid operating system username and password. The SQL*Plus script is run by SQL*Plus executable. The job using this program may point to a connect credential that contains a database credential. If so, this credential is used to connect to the database before running the SQL*Plus script.
Note that if you choose to use connect credential, you must use set_attribute to specify the Connect_Credential_Name attribute. If you do not have connect credential, you must include an explicit SQL*Plus connect statement providing a valid database userid / password.