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
Lab:
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