OCP-1Z0-053-V12.02-512题【转】

weixin_30730151

于 2014-07-10 16:06:00 发布

阅读量49

点赞数

原文链接：http://www.cnblogs.com/oraclesea/p/3835929.html

版权

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