调度程序1

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