http://blog.csdn.net/gisinfo/article/details/8159875
1.Which two statements correctly describe the relationship among the Scheduler components: job, program,
and schedule? (Choose two)
A. A job is specified as part of a program definition
B. A program can be used in the definition of multiple jobs
C. A program and job can be specified as part of a schedule definition
D. A program and schedule can be specified as part of a job definition
Answer: B,D
实验:
SQL> desc dbms_scheduler.create_program
Parameter Type Mode Default?
------------------- -------------- ---- --------
PROGRAM_NAME VARCHAR2 IN
PROGRAM_TYPE VARCHAR2 IN
PROGRAM_ACTION VARCHAR2 IN
NUMBER_OF_ARGUMENTS BINARY_INTEGER IN Y
ENABLED BOOLEAN IN Y
COMMENTS VARCHAR2 IN Y
SQL> desc dbms_scheduler.create_schedule
Parameter Type Mode Default?
--------------- ------------------------ ---- --------
SCHEDULE_NAME VARCHAR2 IN
START_DATE TIMESTAMP WITH TIME ZONE IN Y
REPEAT_INTERVAL VARCHAR2 IN
END_DATE TIMESTAMP WITH TIME ZONE IN Y
COMMENTS VARCHAR2 IN Y